"cityofnewyork-us/parking-regulation-locations-and-signs-nfid-uabd:latest"."parking_regulation_locations_and_signs"

SELECT
    ":id", -- Socrata column ID
    "sign_x_coord", -- The longitude of the sign location
    "sign_size", -- Dimensions of sign, height by width.
    "order_type", -- Order type, represents both regulatory category and geometry.
    "arrow_direction", -- "The direction that an arrow on a sign points.  For a block front sign, this is relative to the ""side of street"" direction.  For an intersection sign, it is relative to the street that is assumed north.  Arrow direction is generally applicable only to block front signs, with one significant exception--""One Way"" intersection signs always have an arrow direction.  Only block front signs with a single arrow will have an arrow direction, signs with no arrow or a double arrow will not."
    "from_street", -- For block front and stretch geometries, the street that intersects at the beginning of the block; for an intersection geometry, the minor intersecting street.
    "from_street_suffix", -- Used in cases where an additional field is needed to create a unique location, such as when two streets intersect twice, and/or where there is an additional roadbed.
    "to_street", -- For block front and stretch geometries, the street that intersects at the end of the block; not applicable (null) for an intersection geometry.
    "on_street_suffix", -- Used in cases where an additional field is needed to create a unique location, such as when two streets intersect twice, and/or where there is an additional roadbed.
    "facing_direction", -- "The general rule is that all intersection signs have a facing direction, with the exception of ""One Way"" signs, which only have an ""arrow points"" direction.  There are a few other minor exceptions.  The direction that a sign faces is relative to the ""Street Assumed North/South"".  Block front signs should never have a facing direction, with a few very minor exceptions."
    "order_number", -- Sign, Parking, Regulation, SIMS, STATUS, Location, Street
    "sign_description", -- Includes description of regulation and superseding/superseded sign design if any.
    "on_street", -- For block front and stretch geometries, where the street the signs are on; for an intersection geometry, the major intersecting street.
    "order_completed_on_date", -- The date the order was closed.
    "record_type", -- The totality of signs associated with "Current" sign orders represents the current asset inventory. Repair (R-) orders are always historical.
    "sheeting_type", -- The surface material used for a sign; the current standard is TIII for an intersection sign and "Painted" (PNTD) for a block front sign.
    "sign_code", -- A unique identifier for a sign design.  (Note, the sign code identifies the sign design, not an instance of a sign on the street that uses that design.)
    "sign_design_voided_on_date", -- Date the system started blocking the use of a defunct sign design.
    "borough", -- Lists which of the five administrative divisions of New York City the work order is located in, written as a word. 
    "distance_from_intersection", -- All block front signs have a distance, which is relative to the curb line; intersection signs will have a distance only if the sign is physically located outside the intersection.
    "to_street_suffix", -- Used in cases where an additional field is needed to create a unique location, such as when two streets intersect twice, and/or where there is an additional roadbed.
    "side_of_street", -- For block front and stretch geometries, the side of street, as all block front and stretch orders are written for only one side of a street.
    "sign_notes", -- Notes that provide regulatory information about a particular sign sequence, such as a Bus Stop ID, name or destination, or something unusual about the location or installation of the sign.
    "sign_y_coord", -- The latitude of the sign location
    "sign_location", -- Applicable only to intersection geometry orders and null for all others, an acronym that indicates the placement of a sign within an intersection.
    "support" -- An acronym that represents the type of structure support the signs.
FROM
    "cityofnewyork-us/parking-regulation-locations-and-signs-nfid-uabd:latest"."parking_regulation_locations_and_signs"
LIMIT 100;

sgr clone cityofnewyork-us/parking-regulation-locations-and-signs-nfid-uabd

sgr checkout cityofnewyork-us/parking-regulation-locations-and-signs-nfid-uabd:latest

sgr checkout --layered cityofnewyork-us/parking-regulation-locations-and-signs-nfid-uabd:latest