trees
2,421 rows where qSpecies_id = 8 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2248 | 90191 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1860X Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.44542 | 37.7766336380006 | -122.478900695137 | (37.7766336380006, -122.478900695137) | 11 | 6 | 2 | 55 | 26 | |||
6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
61559 | 92240 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.490674680595 | (37.7597856659048, -122.490674680595) | 1 | 8 | 3 | 56 | 35 | |||
63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
72474 | 108891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.224 | 37.7307509423916 | -122.447388264722 | (37.7307509423916, -122.447388264722) | 9 | 7 | 4 | 59 | 40 | |
73087 | 88794 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1240 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2010 12:00:00 AM | 3x3 | Permit Number 51706 | 5994624.7 | 2107112.8 | 37.7654212536678 | -122.461828244278 | (37.7654212536678, -122.461828244278) | 15 | 5 | 11 | 56 | 12 | |||
76415 | 87186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864 | 2119027 | 37.7986055186493 | -122.434182233436 | (37.7986055186493, -122.434182233436) | 13 | 9 | 1 | 57 | 17 | |||
77340 | 254477 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778443 | 5993977.44675 | 2106077.77361 | 37.7625420596989 | -122.463991787904 | (37.7625420596989, -122.463991787904) | 1 | 5 | 11 | 56 | 12 | |
81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
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 | |||
91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 | |
92322 | 88205 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51210 | 5998774 | 2109909 | 37.7733369001006 | -122.447678136621 | (37.7733369001006, -122.447678136621) | 15 | 5 | 11 | 29492 | 16 | |||
102845 | 88616 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51569 | 5994405.1 | 2112223.6 | 37.7794415135995 | -122.46295861509 | (37.7794415135995, -122.46295861509) | 11 | 6 | 2 | 54 | 11 | |||
109402 | 255703 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782078 | 6009781.99069 | 2112750.42942 | 37.7817617797421 | -122.409800416291 | (37.7817617797421, -122.409800416291) | 14 | 2 | 9 | 28853 | 34 | |
112848 | 87757 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 375 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50411 | 6001812 | 2103665 | 37.7563655677175 | -122.436722244288 | (37.7563655677175, -122.436722244288) | 2 | 4 | 5 | 28862 | 3 | |||
116488 | 108888 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772760 | 5997727.10617 | 2094743.09717 | 37.7316352013333 | -122.450206090909 | (37.7316352013333, -122.450206090909) | 9 | 7 | 4 | 59 | 40 | |
131090 | 94553 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 634 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53730 | 5998522 | 2108509 | 37.7694784520689 | -122.448448994315 | (37.7694784520689, -122.448448994315) | 15 | 5 | 11 | 29492 | 9 | ||
138668 | 88379 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 351 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51357 | 5990853.6 | 2113045.1 | 37.7814919173335 | -122.475304621963 | (37.7814919173335, -122.475304621963) | 11 | 6 | 2 | 54 | 26 | |||
140580 | 94897 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1375 Keith St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 53955 | 6016208.4 | 2094705 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | 10 | 3 | 8 | 58 | 1 | |||
143403 | 88383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51361 | 5990241.51216 | 2114541.21965 | 37.7855643469481 | -122.477531513518 | (37.7855643469481, -122.477531513518) | 11 | 6 | 2 | 55 | 26 | ||
145397 | 255506 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 Edna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 781977 | 5998590.12208 | 2094762.17227 | 37.7317369269488 | -122.447223858431 | (37.7317369269488, -122.447223858431) | 9 | 7 | 4 | 59 | 40 | ||
145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
156250 | 88556 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 623 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51501 | 5990912.1 | 2111136.5 | 37.7762548179365 | -122.474962880652 | (37.7762548179365, -122.474962880652) | 11 | 6 | 2 | 54 | 26 | |||
157804 | 88392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 22nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51370 | 5989049.86115 | 2113182.34537 | 37.7817640398692 | -122.481554671506 | (37.7817640398692, -122.481554671506) | 11 | 6 | 2 | 55 | 26 | ||
158740 | 94125 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1478 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2010 12:00:00 AM | 3x3 | Permit Number 53485 | 5986246.3 | 2105188 | 37.7596504010073 | -122.490665173884 | (37.7596504010073, -122.490665173884) | 1 | 8 | 3 | 56 | 35 | |||
162179 | 85184 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 Bartlett St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822 | 2100867 | 37.7489663498096 | -122.419197411761 | (37.7489663498096, -122.419197411761) | 2 | 4 | 7 | 28859 | 19 | |||
180570 | 254755 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3044 Ulloa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778626 | 5986607.78234 | 2098260.29291 | 37.7406498995894 | -122.488905737407 | (37.7406498995894, -122.488905737407) | 1 | 8 | 3 | 29491 | 35 | ||
180588 | 87454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2516 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50378 | 6000865 | 2118972 | 37.7983408450274 | -122.441095438221 | (37.7983408450274, -122.441095438221) | 13 | 9 | 1 | 57 | 17 | |||
186715 | 90190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1844 Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.55594 | 37.7766347733354 | -122.478851145848 | (37.7766347733354, -122.478851145848) | 11 | 6 | 2 | 55 | 26 | |||
187067 | 88204 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51209 | 5998766 | 2109964 | 37.7734874588052 | -122.447709769744 | (37.7734874588052, -122.447709769744) | 15 | 5 | 11 | 29492 | 16 | |||
187900 | 88589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 874 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.483083792767 | (37.7731428326728, -122.483083792767) | 11 | 6 | 2 | 55 | 26 | ||
31166 | 191060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.403252800969 | (37.7789796735174, -122.403252800969) | 14 | 2 | 9 | 28856 | 34 | |||
68081 | 191061 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | 14 | 2 | 9 | 28856 | 34 | |||
10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
32 | 264850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 172 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007951 | 2093149 | 37.7278379340298 | -122.414747181337 | (37.7278379340298, -122.414747181337) | 9 | 3 | 7 | 309 | 5 | |||
495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
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 | |||
1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 7 | 7 | 28859 | 2 | |||
1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1238 | 144982 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990689.31249 | 2110785.3324 | 37.7752776943529 | -122.4757079065 | (37.7752776943529, -122.4757079065) | 11 | 6 | 2 | 54 | 26 | ||
1268 | 261097 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 | ||
1304 | 91006 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5988072.26413 | 2111179.36369 | 37.7762075240837 | -122.484789675521 | (37.7762075240837, -122.484789675521) | 11 | 6 | 2 | 55 | 26 | ||
1327 | 261443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007142 | 2095710 | 37.7348243937619 | -122.417725367022 | (37.7348243937619, -122.417725367022) | 2 | 7 | 7 | 28859 | 2 | ||||
1419 | 148015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002502.98722 | 2088786.72578 | 37.7155524923237 | -122.433269485517 | (37.7155524923237, -122.433269485517) | 9 | 7 | 6 | 28861 | 5 | |||
1507 | 74233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010292.05063 | 2106000.69739 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | 8 | 4 | 8 | 28859 | 19 | |||
1628 | 72055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008082.6141 | 2119894.27994 | 37.8012816578905 | -122.416185586193 | (37.8012816578905, -122.416185586193) | 5 | 1 | 1 | 308 | 32 | |||
1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
1793 | 260413 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1510 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015825 | 2096697 | 37.7380192974637 | -122.387773802776 | (37.7380192974637, -122.387773802776) | 10 | 3 | 8 | 58 | 1 | ||||
1997 | 61779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 9 | Permit Number 21800 | 6011831.44367 | 2102306.03776 | 37.7531984774519 | -122.401975779864 | (37.7531984774519, -122.401975779864) | 10 | 3 | 8 | 28856 | 29 | |
2148 | 154032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1662 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014879.40227 | 2097032.81009 | 37.7388889362706 | -122.391066694069 | (37.7388889362706, -122.391066694069) | 10 | 3 | 8 | 58 | 1 | |||
2337 | 223401 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3647 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005476.77928 | 2102530.01598 | 37.7534567573481 | -122.423967438743 | (37.7534567573481, -122.423967438743) | 2 | 4 | 5 | 28859 | 19 | |||
2408 | 162789 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 237 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996026.23717 | 2090535.13208 | 37.71998365171 | -122.455782228671 | (37.71998365171, -122.455782228671) | 9 | 8 | 6 | 28861 | 24 | |||
2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
2532 | 72297 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.434290747523 | (37.7209821527804, -122.434290747523) | 9 | 7 | 6 | 28861 | 5 | |||
2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
3110 | 126516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3449 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5997745.83933 | 2116374.85745 | 37.7910316321555 | -122.451701179872 | (37.7910316321555, -122.451701179872) | 11 | 6 | 1 | 54 | 31 | |||
3218 | 84023 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 309 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 773233 | 6004808.26935881 | 2101900.57071737 | 37.7516906826671 | -122.42623448013 | (37.7516906826671, -122.42623448013) | 2 | 4 | 5 | 28862 | 22 | ||
3265 | 255205 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
3440 | 223611 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006745.90219 | 2102323.75764 | 37.752961988114 | -122.419563899379 | (37.752961988114, -122.419563899379) | 2 | 4 | 7 | 28859 | 19 | |||
3623 | 69046 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3623 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 3 | Permit Number 33053 | 5984457.0554 | 2106305.4338 | 37.762613882253 | -122.496935660667 | (37.762613882253, -122.496935660667) | 1 | 8 | 3 | 56 | 35 | |
3646 | 189251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | 10 | 3 | 8 | 58 | 1 | |||
3696 | 262180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 263 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009676.04228 | 2087903.41357 | 37.713531417046 | -122.408413797613 | (37.713531417046, -122.408413797613) | 9 | 7 | 8 | 309 | 39 | ||
3799 | 63192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 7 | Permit Number 33572 | 5984052.00356 | 2112858.19024 | 37.7805821307687 | -122.498820690141 | (37.7805821307687, -122.498820690141) | 11 | 6 | 2 | 55 | 26 | |
3936 | 172254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1007 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004516.89039 | 2090643.22078 | 37.7207640671979 | -122.426440635537 | (37.7207640671979, -122.426440635537) | 9 | 7 | 6 | 28861 | 5 | |||
3971 | 172343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001347.87441 | 2087361.61872 | 37.7115738673031 | -122.437160092082 | (37.7115738673031, -122.437160092082) | 9 | 7 | 6 | 28861 | 5 | |||
4081 | 145032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 154 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 5991192.39146 | 2114393.22168 | 37.7852131174265 | -122.47423097869 | (37.7852131174265, -122.47423097869) | 11 | 6 | 2 | 54 | 26 | |||
4187 | 78365 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | 9 | 7 | 6 | 28861 | 5 | |||
4370 | 38420 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
4434 | 31506 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 275 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 7 | Permit Number 35066 | 5998177.9524 | 2112750.4955 | 37.7811048271727 | -122.449944767442 | (37.7811048271727, -122.449944767442) | 15 | 6 | 2 | 54 | 16 | |
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 | ||
4551 | 189261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011901.66973 | 2098145.68488 | 37.7417789652237 | -122.401440561855 | (37.7417789652237, -122.401440561855) | 10 | 3 | 8 | 58 | 1 | |||
4685 | 163919 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 528 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785290 | 5993187.06549 | 2105302.66577 | 37.7603682343238 | -122.466669061634 | (37.7603682343238, -122.466669061634) | 1 | 8 | 4 | 56 | 12 | |
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 | ||
5105 | 153628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3140 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780837 | 6004230.96494 | 2119993.8857 | 37.8013378259475 | -122.429521095049 | (37.8013378259475, -122.429521095049) | 13 | 9 | 1 | 57 | 17 | |
5142 | 259872 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
5257 | 62102 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 440 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22195 | 6006762.92692973 | 2101210.352632 | 37.7499057910946 | -122.419426042368 | (37.7499057910946, -122.419426042368) | 2 | 4 | 7 | 28859 | 19 | ||
5283 | 71380 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1415 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015545.815 | 2094978.0232 | 37.7332838660921 | -122.388619133184 | (37.7332838660921, -122.388619133184) | 10 | 3 | 8 | 58 | 1 | |||
5373 | 224056 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4609 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787677 | 6000381.16624 | 2105168.69891 | 37.7604129369301 | -122.441778467817 | (37.7604129369301, -122.441778467817) | 2 | 4 | 5 | 28862 | 3 | |
5548 | 64543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | 10 | 3 | 8 | 58 | 1 | ||
5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
5953 | 181063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:21:00 PM | 3 | Width 3ft | 5999687.90058 | 2086653.14824 | 37.7095340664096 | -122.44284654224 | (37.7095340664096, -122.44284654224) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
6010 | 162250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 40 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011508.76761 | 2091210.5075 | 37.7227144898747 | -122.402311591215 | (37.7227144898747, -122.402311591215) | 10 | 3 | 7 | 309 | 28 | ||
6040 | 90220 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987751.08815 | 2111228.00123 | 37.7763223582458 | -122.485904267418 | (37.7763223582458, -122.485904267418) | 11 | 6 | 2 | 55 | 26 | ||
6315 | 46517 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | ||
6423 | 161312 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6002939.11369 | 2090932.78769 | 37.7214698362342 | -122.431915186563 | (37.7214698362342, -122.431915186563) | 9 | 7 | 6 | 28861 | 5 | ||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 |
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) );