trees
220 rows where Fire Prevention Districts = 15 and qSpecies_id = 8 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11873 | 224059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.7642765053752 | -122.433866946505 | (37.7642765053752, -122.433866946505) | 15 | 5 | 5 | 28862 | 3 | |||
| 23536 | 108612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | 15 | 5 | 5 | 28862 | 3 | |
| 32252 | 224064 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 253 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999797.09097 | 2105500.9321 | 37.761291869548 | -122.443822376823 | (37.761291869548, -122.443822376823) | 15 | 5 | 5 | 28862 | 3 | |||
| 43626 | 224068 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999966.77675 | 2105730.11329 | 37.7619308216632 | -122.443251968323 | (37.7619308216632, -122.443251968323) | 15 | 5 | 5 | 28862 | 3 | |||
| 50886 | 224065 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 249 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999809.62002 | 2105505.92118 | 37.7613062829657 | -122.443779402711 | (37.7613062829657, -122.443779402711) | 15 | 5 | 5 | 28862 | 3 | |||
| 63958 | 224074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000120.5306 | 2105737.10034 | 37.7619587726053 | -122.442720697406 | (37.7619587726053, -122.442720697406) | 15 | 5 | 5 | 28862 | 3 | |||
| 72578 | 257907 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 44 Clarendon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998004 | 2104650 | 37.7588529837709 | -122.449962562921 | (37.7588529837709, -122.449962562921) | 15 | 5 | 4 | 28862 | 38 | ||||
| 77440 | 115160 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 80482 | 224066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 249 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999824.86167 | 2105514.60319 | 37.7613309909564 | -122.443727312184 | (37.7613309909564, -122.443727312184) | 15 | 5 | 5 | 28862 | 3 | |||
| 87693 | 224063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 253 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999782.69544 | 2105496.73151 | 37.7612795146477 | -122.443871862914 | (37.7612795146477, -122.443871862914) | 15 | 5 | 5 | 28862 | 3 | |||
| 108481 | 224076 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4347 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000486.58974 | 2105759.50632 | 37.7620411550071 | -122.441456253314 | (37.7620411550071, -122.441456253314) | 15 | 5 | 5 | 28862 | 3 | |||
| 119910 | 115159 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 119980 | 224070 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000003.97958 | 2105733.89471 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | 15 | 5 | 5 | 28862 | 3 | |||
| 133465 | 59743 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4377 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22594 | 6000259.423804 | 2105746.15937443 | 37.7619915633709 | -122.442240971868 | (37.7619915633709, -122.442240971868) | 15 | 5 | 5 | 28862 | 3 | ||
| 137142 | 224073 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000107.64 | 2105738.17174 | 37.7619609795428 | -122.442765357751 | (37.7619609795428, -122.442765357751) | 15 | 5 | 5 | 28862 | 3 | |||
| 138810 | 224077 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4333 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000578.70387 | 2105764.82815 | 37.762061014736 | -122.44113804889 | (37.762061014736, -122.44113804889) | 15 | 5 | 5 | 28862 | 3 | |||
| 150904 | 224067 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 198 Corbin Pl | 2 | Side Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6000076.79704 | 2105677.05366 | 37.7617914060643 | -122.442867642133 | (37.7617914060643, -122.442867642133) | 15 | 5 | 5 | 28862 | 3 | |||
| 152194 | 224058 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002712.47217 | 2106530.01609 | 37.7642833447214 | -122.433812870289 | (37.7642833447214, -122.433812870289) | 15 | 5 | 5 | 28862 | 3 | |||
| 158037 | 224069 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999992.96572 | 2105734.65927 | 37.7619447971247 | -122.443161717741 | (37.7619447971247, -122.443161717741) | 15 | 5 | 5 | 28862 | 3 | |||
| 162463 | 224072 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000093.36595 | 2105737.39642 | 37.7619580369572 | -122.442814670284 | (37.7619580369572, -122.442814670284) | 15 | 5 | 5 | 28862 | 3 | |||
| 162573 | 62434 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4347 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22595 | 6000487.62701634 | 2105758.51838651 | 37.7620385014788 | -122.441452594893 | (37.7620385014788, -122.441452594893) | 15 | 5 | 5 | 28862 | 3 | ||
| 169820 | 224075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4377 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000260.08282 | 2105746.79399 | 37.7619933434277 | -122.442238738154 | (37.7619933434277, -122.442238738154) | 15 | 5 | 5 | 28862 | 3 | |||
| 178149 | 115161 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 179767 | 224078 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 37 Mars St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 5999600.02239 | 2105581.97574 | 37.7615031526571 | -122.444509776331 | (37.7615031526571, -122.444509776331) | 15 | 5 | 5 | 28862 | 3 | |||
| 190526 | 62432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50975 | 5999996.18953726 | 2105731.90313751 | 37.7619374132884 | -122.443150369901 | (37.7619374132884, -122.443150369901) | 15 | 5 | 5 | 28862 | 3 | ||
| 194167 | 224071 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000023.07731 | 2105733.76605 | 37.7619440614764 | -122.443057509717 | (37.7619440614764, -122.443057509717) | 15 | 5 | 5 | 28862 | 3 | |||
| 12961 | 70529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1930 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | Permit Number 782472 | 5999916.9745 | 2111278.4432 | 37.7771623000193 | -122.443822848555 | (37.7771623000193, -122.443822848555) | 15 | 5 | 11 | 29490 | 16 | ||
| 49564 | 114655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001302.3779 | 2113905.5111 | 37.7844544851842 | -122.439218650192 | (37.7844544851842, -122.439218650192) | 15 | 6 | 11 | 29490 | 13 | |||
| 52716 | 114651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001524.5433 | 2113938.4711 | 37.7845576244995 | -122.438452398093 | (37.7845576244995, -122.438452398093) | 15 | 6 | 11 | 29490 | 13 | |||
| 66207 | 41815 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Barcelona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | 15 | 5 | 1 | 29490 | 16 | ||
| 96689 | 137622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2055 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000170.6646 | 2111954.7813 | 37.7790338187699 | -122.442993839351 | (37.7790338187699, -122.442993839351) | 15 | 5 | 11 | 29490 | 16 | |||
| 111195 | 66496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 6 | Permit Number 29657 | 6001602.2551 | 2113943.9812 | 37.7845771738803 | -122.438183936989 | (37.7845771738803, -122.438183936989) | 15 | 6 | 11 | 29490 | 13 | |
| 113949 | 114653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001412.8316 | 2113920.3557 | 37.7845015292891 | -122.438837583296 | (37.7845015292891, -122.438837583296) | 15 | 6 | 11 | 29490 | 13 | |||
| 124455 | 114649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001565.303 | 2113942.4968 | 37.7845709964296 | -122.43831167213 | (37.7845709964296, -122.43831167213) | 15 | 6 | 11 | 29490 | 13 | |||
| 127391 | 114650 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6001545.1748 | 2113940.4839 | 37.784564324662 | -122.438381164493 | (37.784564324662, -122.438381164493) | 15 | 6 | 11 | 29490 | 13 | |||
| 129950 | 6373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | 15 | 5 | 1 | 29490 | 41 | |||
| 133995 | 38086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2501 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.7849591037257 | -122.441572302214 | (37.7849591037257, -122.441572302214) | 15 | 6 | 11 | 29490 | 13 | ||
| 134349 | 114648 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6001582.412 | 2113946.0192 | 37.7845816411392 | -122.438252733323 | (37.7845816411392, -122.438252733323) | 15 | 6 | 11 | 29490 | 13 | |||
| 135243 | 41814 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Barcelona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | 15 | 5 | 1 | 29490 | 16 | ||
| 155505 | 138750 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 POST ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001227.9034 | 2113893.9374 | 37.7844184685956 | -122.439475475851 | (37.7844184685956, -122.439475475851) | 15 | 6 | 11 | 29490 | 13 | |||
| 160324 | 139106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2549 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999977.0599 | 2113664.9676 | 37.7837185099966 | -122.443786492869 | (37.7837185099966, -122.443786492869) | 15 | 6 | 1 | 29490 | 31 | |||
| 1004 | 50532 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.7641824656847 | -122.454684361894 | (37.7641824656847, -122.454684361894) | 15 | 5 | 11 | 29492 | 12 | |||
| 3320 | 245104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999855.4831 | 2109410.1992 | 37.7720290692692 | -122.443901304248 | (37.7720290692692, -122.443901304248) | 15 | 5 | 11 | 29492 | 9 | |||
| 4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 15 | 5 | 11 | 29492 | 9 | ||
| 4923 | 31224 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 0 | Permit Number 42098 | 5999592.83400965 | 2107841.48506455 | 37.76770679076 | -122.444697050343 | (37.76770679076, -122.444697050343) | 15 | 5 | 11 | 29492 | 9 | ||
| 5449 | 245103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999859.4717 | 2109392.5831 | 37.7719809274281 | -122.443886241527 | (37.7719809274281, -122.443886241527) | 15 | 5 | 11 | 29492 | 9 | |||
| 5985 | 247277 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2015 12:00:00 AM | 9 | Width 0ft | 5998904.2718 | 2109290.33 | 37.7716456345938 | -122.447182976567 | (37.7716456345938, -122.447182976567) | 15 | 5 | 11 | 29492 | 9 | ||
| 9259 | 112872 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5999621 | 2110473 | 37.7749338721416 | -122.444788804756 | (37.7749338721416, -122.444788804756) | 15 | 5 | 11 | 29492 | 16 | |||
| 9337 | 244882 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1397 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999938.3807 | 2109154.2405 | 37.7713309995727 | -122.443596165541 | (37.7713309995727, -122.443596165541) | 15 | 5 | 11 | 29492 | 9 | |||
| 13230 | 260498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 349 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000178 | 2110153 | 37.7740870040886 | -122.442839045318 | (37.7740870040886, -122.442839045318) | 15 | 5 | 11 | 29492 | 16 | ||||
| 13680 | 247278 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2015 12:00:00 AM | 18 | Width 0ft | 5998896.1541 | 2109320.6647 | 37.7717284621218 | -122.447213239628 | (37.7717284621218, -122.447213239628) | 15 | 5 | 11 | 29492 | 9 | ||
| 14615 | 260497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000185 | 2110105 | 37.7739556073117 | -122.44281138372 | (37.7739556073117, -122.44281138372) | 15 | 5 | 11 | 29492 | 16 | ||||
| 14859 | 245105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999853.8212 | 2109427.1506 | 37.7720755187291 | -122.443908271008 | (37.7720755187291, -122.443908271008) | 15 | 5 | 11 | 29492 | 9 | |||
| 15681 | 245106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999851.4945 | 2109440.7782 | 37.7721128039526 | -122.443917298515 | (37.7721128039526, -122.443917298515) | 15 | 5 | 11 | 29492 | 9 | |||
| 20827 | 248510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861 | -122.449287603561 | (37.767563696861, -122.449287603561) | 15 | 5 | 11 | 29492 | 9 | |||
| 20998 | 245940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997158.2972 | 2107852.8817 | 37.7675988557806 | -122.453118590527 | (37.7675988557806, -122.453118590527) | 15 | 5 | 11 | 29492 | 9 | |||
| 23958 | 31714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.88312 | 2105983.06318 | 37.7625196419841 | -122.449671682498 | (37.7625196419841, -122.449671682498) | 15 | 5 | 11 | 29492 | 9 | |
| 24919 | 207665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5996615.28225 | 2106600.56008 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | 15 | 5 | 11 | 29492 | 12 | |||
| 25863 | 248419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 726 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999075.0539 | 2108056.9885 | 37.7682689481267 | -122.446503486875 | (37.7682689481267, -122.446503486875) | 15 | 5 | 11 | 29492 | 9 | |||
| 27943 | 31680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 55 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35186 | 5998329.53554 | 2107192.57672 | 37.7658528820189 | -122.44901987369 | (37.7658528820189, -122.44901987369) | 15 | 5 | 11 | 29492 | 9 | |
| 28205 | 223464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.7659775352626 | -122.448031401823 | (37.7659775352626, -122.448031401823) | 15 | 5 | 11 | 29492 | 9 | |||
| 28703 | 223452 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.7625252312687 | -122.449596269873 | (37.7625252312687, -122.449596269873) | 15 | 5 | 11 | 29492 | 9 | |||
| 29432 | 223456 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998596.25965 | 2106249.17699 | 37.7632777947483 | -122.448029403535 | (37.7632777947483, -122.448029403535) | 15 | 5 | 11 | 29492 | 9 | |||
| 29823 | 207664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 428 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5996430.67292 | 2106975.20707 | 37.7651472586653 | -122.455571889857 | (37.7651472586653, -122.455571889857) | 15 | 5 | 11 | 29492 | 12 | |||
| 31228 | 244888 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 158 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999901.22 | 2109095.6532 | 37.7711680141967 | -122.443720495999 | (37.7711680141967, -122.443720495999) | 15 | 5 | 11 | 29492 | 9 | |||
| 32136 | 223553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1225 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997728.13175 | 2106337.92213 | 37.7634718037012 | -122.451038357055 | (37.7634718037012, -122.451038357055) | 15 | 5 | 11 | 29492 | 9 | |||
| 35252 | 31682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 10 | Permit Number 35188 | 5998292.66632 | 2107186.56904 | 37.765834277768 | -122.449146963179 | (37.765834277768, -122.449146963179) | 15 | 5 | 11 | 29492 | 9 | |
| 38788 | 46109 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 39296 | 254275 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 708 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781292 | 6003166.11525 | 2109644.67448 | 37.7728611677821 | -122.432466329003 | (37.7728611677821, -122.432466329003) | 15 | 5 | 11 | 29492 | 9 |
| 40084 | 223469 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998759.82917 | 2106683.9118 | 37.7644808160601 | -122.447494967025 | (37.7644808160601, -122.447494967025) | 15 | 5 | 11 | 29492 | 9 | |||
| 41200 | 83965 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770970 | 5998650.00823902 | 2107235.22777665 | 37.7659883142219 | -122.447914501463 | (37.7659883142219, -122.447914501463) | 15 | 5 | 11 | 29492 | 9 | |
| 42072 | 39611 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 786 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | 6x6 | Permit Number 44486 | 5998641.21928003 | 2107708.61027258 | 37.7672876005221 | -122.447978986539 | (37.7672876005221, -122.447978986539) | 15 | 5 | 11 | 29492 | 9 | |
| 43406 | 31661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4812 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1995 12:00:00 AM | 8 | Permit Number 35169 | 5998134.62707 | 2105673.01843 | 37.7616694094477 | -122.449584512135 | (37.7616694094477, -122.449584512135) | 15 | 5 | 11 | 29492 | 9 | |
| 49386 | 88828 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 52305 | 223550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997652.48315 | 2106877.54396 | 37.7649491371199 | -122.451338921264 | (37.7649491371199, -122.451338921264) | 15 | 5 | 11 | 29492 | 9 | |||
| 52525 | 41111 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768078 | 5998475.36109431 | 2108520.6824709 | 37.7695078624746 | -122.448611157192 | (37.7695078624746, -122.448611157192) | 15 | 5 | 11 | 29492 | 9 |
| 52643 | 223466 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 871 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5998671.83935 | 2107146.23742 | 37.7657452169834 | -122.447832585123 | (37.7657452169834, -122.447832585123) | 15 | 5 | 11 | 29492 | 9 | |||
| 53524 | 245045 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 145 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000757.5634 | 2109534.6757 | 37.7724222651654 | -122.440789876997 | (37.7724222651654, -122.440789876997) | 15 | 5 | 11 | 29492 | 9 | |||
| 54630 | 245044 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 155 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | 15 | 5 | 11 | 29492 | 9 | |||
| 56364 | 67198 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30650 | 5998389.1076576 | 2106230.44875795 | 37.7632145281987 | -122.448744521857 | (37.7632145281987, -122.448744521857) | 15 | 5 | 11 | 29492 | 9 | ||
| 58713 | 207661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1205 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996709.68526 | 2107252.63916 | 37.7659250229495 | -122.454626903816 | (37.7659250229495, -122.454626903816) | 15 | 5 | 11 | 29492 | 12 | |||
| 59849 | 223448 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997400.9085 | 2105772.15119 | 37.7618996008164 | -122.452129287752 | (37.7618996008164, -122.452129287752) | 15 | 5 | 11 | 29492 | 12 | |||
| 60325 | 217746 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 Frederick St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5996538.5455 | 2107286.52393 | 37.7660082444099 | -122.455221286434 | (37.7660082444099, -122.455221286434) | 15 | 5 | 11 | 29492 | 12 | |||
| 61407 | 207660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996711.46943 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | 15 | 5 | 11 | 29492 | 12 | |||
| 63409 | 46246 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | |||
| 63990 | 46247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | ||
| 64377 | 31707 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 492 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35209 | 5997285.6368 | 2107441.337 | 37.7664761565817 | -122.452648436505 | (37.7664761565817, -122.452648436505) | 15 | 5 | 11 | 29492 | 9 | |
| 66835 | 31708 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 498 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35209 | 5997262.9247 | 2107438.6115 | 37.7664673716678 | -122.452726796412 | (37.7664673716678, -122.452726796412) | 15 | 5 | 11 | 29492 | 9 | ||
| 67585 | 224096 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 310 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003743.84038 | 2108689.19941 | 37.7702704103723 | -122.430399726373 | (37.7702704103723, -122.430399726373) | 15 | 9 | 11 | 29492 | 10 | |||
| 68644 | 223468 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998354.91827 | 2106850.96431 | 37.7649163523355 | -122.448907471004 | (37.7649163523355, -122.448907471004) | 15 | 5 | 11 | 29492 | 9 | |||
| 69440 | 31713 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 43549 | 5998153.78946 | 2105987.36259 | 37.7625336156627 | -122.44954088871 | (37.7625336156627, -122.44954088871) | 15 | 5 | 11 | 29492 | 9 | |
| 73755 | 223547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996845.23673 | 2107329.23539 | 37.7661431103528 | -122.454163594697 | (37.7661431103528, -122.454163594697) | 15 | 5 | 11 | 29492 | 12 | |||
| 73797 | 141629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1801 GROVE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999005.9913 | 2110412.5019 | 37.7747326436678 | -122.446911888169 | (37.7747326436678, -122.446911888169) | 15 | 5 | 11 | 29492 | 16 | |||
| 77306 | 31710 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 619 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35210 | 5996583.34698 | 2107294.12432 | 37.7660316834511 | -122.45506687734 | (37.7660316834511, -122.45506687734) | 15 | 5 | 11 | 29492 | 12 | |
| 77634 | 67192 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30642 | 5997398.59481409 | 2105779.27985473 | 37.7619190417907 | -122.452137804207 | (37.7619190417907, -122.452137804207) | 15 | 5 | 11 | 29492 | 12 | ||
| 77755 | 246054 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 634 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998531.0214 | 2108461.1139 | 37.7693474848137 | -122.448414340817 | (37.7693474848137, -122.448414340817) | 15 | 5 | 11 | 29492 | 9 | |||
| 78417 | 207663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5996706.11666 | 2107295.55996 | 37.7660426677731 | -122.454642347884 | (37.7660426677731, -122.454642347884) | 15 | 5 | 11 | 29492 | 12 | |||
| 79304 | 224061 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 181 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001736.66137 | 2107755.21025 | 37.7675920053907 | -122.437275651355 | (37.7675920053907, -122.437275651355) | 15 | 5 | 5 | 29492 | 3 | |||
| 79722 | 47754 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 45534 | 6003126.79155658 | 2109592.75856581 | 37.7727163895077 | -122.43259864509 | (37.7727163895077, -122.43259864509) | 15 | 5 | 11 | 29492 | 9 | ||
| 80102 | 88825 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 |
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) );