limiting responses to 1000 records for weather and detail endpoints #106
set response limit to 500, ensuring order_by clause for consistent responses