trees
18 rows where Zip Codes = 29490 and qSpecies_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1972 | 64568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1888 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51776 | 6000584.4368 | 2111720.243 | 37.7784134187795 | -122.441545602938 | (37.7784134187795, -122.441545602938) | 15 | 5 | 11 | 29490 | 41 | |
20629 | 51532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.43094 | 37.78839440084 | -122.44482529806 | (37.78839440084, -122.44482529806) | 13 | 6 | 1 | 29490 | 27 | ||
21599 | 129376 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.436181762774 | (37.7925242837291, -122.436181762774) | 13 | 9 | 1 | 29490 | 27 | |||
24170 | 41808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.443787242166 | (37.7796001259133, -122.443787242166) | 15 | 5 | 1 | 29490 | 16 | |
29952 | 137671 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | 15 | 5 | 11 | 29490 | 16 | |||
41709 | 129378 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002236.43678 | 2116865.63553 | 37.7926353355998 | -122.436199040575 | (37.7926353355998, -122.436199040575) | 13 | 9 | 1 | 29490 | 27 | |||
43690 | 52885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500@ JACKSON Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 7 | Permit Number 48890 | 6002243.8338 | 2116804.81477 | 37.7924687577648 | -122.436169092224 | (37.7924687577648, -122.436169092224) | 13 | 9 | 1 | 29490 | 27 | ||
44290 | 140758 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.7815689287559 | -122.442554464995 | (37.7815689287559, -122.442554464995) | 15 | 5 | 1 | 29490 | 16 | |||
76341 | 47469 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2907 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45370 | 5999522.715 | 2114292.4911 | 37.7854156010234 | -122.445403484856 | (37.7854156010234, -122.445403484856) | 15 | 6 | 1 | 29490 | 31 | |
95828 | 129377 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002239.2844 | 2116842.37021 | 37.7925716168296 | -122.436187522037 | (37.7925716168296, -122.436187522037) | 13 | 9 | 1 | 29490 | 27 | |||
120895 | 88732 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1732 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51666 | 6003104.1 | 2114241.2 | 37.7854785624412 | -122.433009307654 | (37.7854785624412, -122.433009307654) | 13 | 9 | 11 | 29490 | 13 | ||
126848 | 41809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 2 | Permit Number 42201 | 5999967.3577 | 2112168.7485 | 37.7796097242619 | -122.443712533479 | (37.7796097242619, -122.443712533479) | 15 | 5 | 1 | 29490 | 16 | |
135075 | 52442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.431503592933 | (37.7920224826905, -122.431503592933) | 13 | 9 | 1 | 29490 | 27 | |
136198 | 255789 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2240 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003983 | 2116665 | 37.7921835181407 | -122.430141547967 | (37.7921835181407, -122.430141547967) | 13 | 9 | 1 | 29490 | 27 | ||||
146709 | 254547 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2908 Bush St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781446 | 5999588.42992 | 2114352.40043 | 37.7855838475934 | -122.445180440387 | (37.7855838475934, -122.445180440387) | 15 | 6 | 1 | 29490 | 31 | |
156644 | 41807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999913.2102 | 2112161.3032 | 37.7795861928813 | -122.443899317319 | (37.7795861928813, -122.443899317319) | 15 | 5 | 1 | 29490 | 16 | |
166863 | 140780 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.443550757384 | (37.7796937331341, -122.443550757384) | 15 | 5 | 1 | 29490 | 16 | |||
175521 | 41812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | 15 | 5 | 1 | 29490 | 16 |
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) );