trees
34 rows where Fire Prevention Districts = 3 and qSpecies_id = 8
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6449 | 71444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | 3 | 1 | 10 | 28860 | 6 | |||
| 8480 | 72470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012030.25538 | 2119045.53422 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | 3 | 1 | 10 | 308 | 23 | |||
| 8533 | 71618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012375.88529 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | 3 | 1 | 10 | 28860 | 6 | |||
| 10927 | 74852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | 3 | 1 | 10 | 308 | 4 | |||
| 12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 15002 | 73575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | 3 | 1 | 10 | 28860 | 6 | |||
| 15380 | 74967 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012084.12824 | 2119041.91729 | 37.7991654604723 | -122.402278540244 | (37.7991654604723, -122.402278540244) | 3 | 1 | 10 | 28860 | 6 | ||
| 15688 | 126539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008917.81168 | 2119409.99919 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | 3 | 1 | 10 | 308 | 32 | |||
| 16533 | 74989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.412162212732 | (37.798876023557, -122.412162212732) | 3 | 1 | 10 | 308 | 4 | |||
| 25321 | 126537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | 3 | 1 | 10 | 308 | 32 | |||
| 26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
| 33909 | 71627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.7989453738906 | -122.402416977385 | (37.7989453738906, -122.402416977385) | 3 | 1 | 10 | 308 | 23 | ||
| 36123 | 126557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | 3 | 1 | 10 | 308 | 23 | |||
| 39577 | 126542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 789 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009244.5501 | 2119059.64752 | 37.7990552287775 | -122.412105741595 | (37.7990552287775, -122.412105741595) | 3 | 1 | 10 | 308 | 4 | |||
| 40787 | 64563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.7949443413606 | -122.409858709005 | (37.7949443413606, -122.409858709005) | 3 | 1 | 10 | 28857 | 4 | |
| 41731 | 126559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.7996220201986 | -122.402563960758 | (37.7996220201986, -122.402563960758) | 3 | 1 | 10 | 308 | 23 | |||
| 45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
| 45874 | 126550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.7986426917617 | -122.402360227452 | (37.7986426917617, -122.402360227452) | 3 | 1 | 10 | 308 | 23 | |||
| 47502 | 126551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 953 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012059.41755 | 2118828.15816 | 37.7985771500692 | -122.402349010193 | (37.7985771500692, -122.402349010193) | 3 | 1 | 10 | 308 | 23 | |||
| 54705 | 126555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | 3 | 1 | 10 | 308 | 23 | |||
| 63290 | 126560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | 3 | 1 | 10 | 308 | 23 | |||
| 71572 | 126556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499876 | -122.402609980888 | (37.799883499876, -122.402609980888) | 3 | 1 | 10 | 308 | 23 | |||
| 78300 | 126552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012094.9021 | 2119101.47961 | 37.7993296056227 | -122.402245448777 | (37.7993296056227, -122.402245448777) | 3 | 1 | 10 | 28860 | 6 | |||
| 86029 | 112676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |||
| 88936 | 88727 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51662 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 96112 | 126554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | 3 | 1 | 10 | 308 | 23 | |||
| 112367 | 59922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1501 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19392 | 6009252.52632 | 2118479.54886 | 37.797462868466 | -122.412037123318 | (37.797462868466, -122.412037123318) | 3 | 1 | 10 | 308 | 21 | |
| 113991 | 126532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | 3 | 1 | 10 | 28857 | 4 | |||
| 116323 | 126538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 846 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | 3 | 1 | 10 | 308 | 32 | |||
| 143270 | 88403 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071 | 2119078 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | 3 | 1 | 10 | 308 | 32 | ||
| 148110 | 126540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509 | -122.414125355424 | (37.800243203509, -122.414125355424) | 3 | 1 | 10 | 308 | 32 | |||
| 164066 | 64564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1011 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 11 | Permit Number 25456 | 6009907.55581 | 2117242.96669 | 37.7941042450764 | -122.409683212627 | (37.7941042450764, -122.409683212627) | 3 | 1 | 10 | 28857 | 21 | |
| 169709 | 126558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | 3 | 1 | 10 | 308 | 23 | |||
| 194176 | 126553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.402179267671 | (37.7993378371204, -122.402179267671) | 3 | 1 | 10 | 28860 | 6 |
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) );