trees
22 rows where Zip Codes = 29491 and qSpecies_id = 66 sorted by Zip Codes
This data as json, CSV (advanced)
These facets timed out: Zip Codes
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153 | 185313 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984983.1747 | 2097234.3473 | 37.7377379790483 | -122.494447317023 | (37.7377379790483, -122.494447317023) | 1 | 8 | 3 | 29491 | 35 | |||
13397 | 185258 | DPW Maintained 1 | Shrub :: Shrub 66 | 2101 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986433.4347 | 2097526.3066 | 37.7386243913853 | -122.489454599165 | (37.7386243913853, -122.489454599165) | 1 | 8 | 3 | 29491 | 35 | |||
17255 | 185555 | DPW Maintained 1 | Shrub :: Shrub 66 | 2201 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984902.7901 | 2099826.3861 | 37.7448503133319 | -122.494916305221 | (37.7448503133319, -122.494916305221) | 1 | 8 | 3 | 29491 | 35 | |||
27497 | 21133 | DPW Maintained 1 | Shrub :: Shrub 66 | 2292X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | ||||
27654 | 187054 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984950.4566 | 2097599.3275 | 37.7387382018833 | -122.494587336532 | (37.7387382018833, -122.494587336532) | 1 | 8 | 3 | 29491 | 35 | |||
34922 | 185312 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984965.1696 | 2097238.5346 | 37.7377484224906 | -122.494509877006 | (37.7377484224906, -122.494509877006) | 1 | 8 | 3 | 29491 | 35 | |||
53305 | 187234 | DPW Maintained 1 | Shrub :: Shrub 66 | 2401 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984956.0101 | 2098625.8109 | 37.7415569740276 | -122.494643790117 | (37.7415569740276, -122.494643790117) | 1 | 8 | 3 | 29491 | 35 | |||
66325 | 187025 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984975.6777 | 2097882.1396 | 37.7395162040617 | -122.494520977899 | (37.7395162040617, -122.494520977899) | 1 | 8 | 3 | 29491 | 35 | |||
67903 | 181355 | DPW Maintained 1 | Shrub :: Shrub 66 | 2300 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985079.1419 | 2099429.3232 | 37.7437704079628 | -122.494277260962 | (37.7437704079628, -122.494277260962) | 1 | 8 | 3 | 29491 | 35 | |||
68765 | 185897 | DPW Maintained 1 | Shrub :: Shrub 66 | 2000 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985016.2502 | 2101239.5934 | 37.7487372369942 | -122.494628152274 | (37.7487372369942, -122.494628152274) | 1 | 8 | 3 | 29491 | 35 | |||
77702 | 187253 | DPW Maintained 1 | Shrub :: Shrub 66 | 2401 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.1374 | 2098459.5582 | 37.7411008475889 | -122.494610350765 | (37.7411008475889, -122.494610350765) | 1 | 8 | 3 | 29491 | 35 | |||
94878 | 117511 | DPW Maintained 1 | Shrub :: Shrub 66 | 2634 37TH AVE | 1 | Median : Yard | Landscaping | DPW 1 | 20 | 3x3 | 5984921 | 2097163 | 37.7375384395308 | -122.494657023299 | (37.7375384395308, -122.494657023299) | 1 | 8 | 3 | 29491 | 35 | |||
98817 | 181343 | DPW Maintained 1 | Shrub :: Shrub 66 | 2500 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985164.5677 | 2097705.9234 | 37.7390434150027 | -122.493854905389 | (37.7390434150027, -122.493854905389) | 1 | 8 | 3 | 29491 | 35 | |||
110736 | 187251 | DPW Maintained 1 | Shrub :: Shrub 66 | 2401 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984973.9834 | 2098481.6163 | 37.7411621065182 | -122.494571017919 | (37.7411621065182, -122.494571017919) | 1 | 8 | 3 | 29491 | 35 | |||
126370 | 187377 | DPW Maintained 1 | Shrub :: Shrub 66 | 2200 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985052.2703 | 2100029.8298 | 37.7454176637381 | -122.49441443213 | (37.7454176637381, -122.49441443213) | 1 | 8 | 3 | 29491 | 35 | |||
131527 | 187056 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984980.0493 | 2097557.2924 | 37.7386245167659 | -122.49448192258 | (37.7386245167659, -122.49448192258) | 1 | 8 | 3 | 29491 | 35 | |||
144357 | 187122 | DPW Maintained 1 | Shrub :: Shrub 66 | 2600 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985165.8082 | 2097341.5801 | 37.7380430985113 | -122.493823774181 | (37.7380430985113, -122.493823774181) | 1 | 8 | 3 | 29491 | 35 | |||
147623 | 187053 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984954.1557 | 2097623.876 | 37.7388058219757 | -122.494576356208 | (37.7388058219757, -122.494576356208) | 1 | 8 | 3 | 29491 | 35 | |||
155034 | 185692 | DPW Maintained 1 | Shrub :: Shrub 66 | 2101 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984851.9348 | 2100530.8696 | 37.7467816562023 | -122.495144090409 | (37.7467816562023, -122.495144090409) | 1 | 8 | 3 | 29491 | 35 | |||
158923 | 187055 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984955.8371 | 2097567.7171 | 37.7386517231253 | -122.49456640389 | (37.7386517231253, -122.49456640389) | 1 | 8 | 3 | 29491 | 35 | |||
162770 | 21130 | DPW Maintained 1 | Shrub :: Shrub 66 | 2292X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | ||||
172977 | 185311 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984965.5883 | 2097247.7465 | 37.737773740404 | -122.494509108268 | (37.737773740404, -122.494509108268) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );