trees
2,421 rows where 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7067 | 223489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.73723280954 | -122.415232573728 | (37.73723280954, -122.415232573728) | 2 | 7 | 7 | 28859 | 2 | |||
7204 | 262178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 235 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009840.919 | 2087844.03033 | 37.713377594646 | -122.407839737463 | (37.713377594646, -122.407839737463) | 9 | 7 | 8 | 309 | 39 | ||
7259 | 90542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 632 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993688.832385 | 2110751.462082 | 37.7753581349738 | -122.465329502856 | (37.7753581349738, -122.465329502856) | 11 | 6 | 2 | 54 | 11 | ||
7390 | 27682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.5288809 | 2097124.3937126 | 37.738948976933 | -122.402963228074 | (37.738948976933, -122.402963228074) | 10 | 3 | 8 | 58 | 1 | ||
7451 | 255209 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
7521 | 82066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 178 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6x9 | 5993381.48495 | 2114348.32206 | 37.7852164089009 | -122.466654188344 | (37.7852164089009, -122.466654188344) | 11 | 6 | 2 | 54 | 11 | ||
7695 | 262179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009723.14992 | 2087886.44693 | 37.713487468075 | -122.408249780165 | (37.713487468075, -122.408249780165) | 9 | 7 | 8 | 309 | 39 | ||
7729 | 223606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007244.98796 | 2104086.07115 | 37.7578289967226 | -122.417962880381 | (37.7578289967226, -122.417962880381) | 2 | 4 | 7 | 28859 | 19 | |||
7733 | 170655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000850.12796 | 2092564.23012 | 37.7258307594577 | -122.439253095949 | (37.7258307594577, -122.439253095949) | 9 | 7 | 6 | 28861 | 25 | ||
7760 | 261189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
7811 | 10192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005805.59526 | 2102140.15786 | 37.7524048554241 | -122.422802617046 | (37.7524048554241, -122.422802617046) | 2 | 4 | 5 | 28859 | 19 | ||
8093 | 223555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
8207 | 47474 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
8256 | 144400 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5987240.24391 | 2111690.94043 | 37.7775636765575 | -122.487705414786 | (37.7775636765575, -122.487705414786) | 11 | 6 | 2 | 55 | 26 | |||
8415 | 96169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767802 | 6007419 | 2097998 | 37.7411223211925 | -122.416929733801 | (37.7411223211925, -122.416929733801) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
8512 | 117149 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.15518 | 2097982.19203 | 37.7413315821976 | -122.401334038935 | (37.7413315821976, -122.401334038935) | 10 | 3 | 8 | 58 | 1 | |
8525 | 117146 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
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 | |||
8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
8760 | 28315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.99062 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | 2 | 7 | 7 | 28859 | 2 | |
8807 | 224036 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2016 07:10:00 AM | 2 | Width 3ft | 6002606.66337 | 2101060.9954 | 37.7492607194187 | -122.433787912303 | (37.7492607194187, -122.433787912303) | 2 | 4 | 5 | 28862 | 22 | ||
8809 | 223493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007980.72085 | 2102939.00638 | 37.7547207985381 | -122.415337199951 | (37.7547207985381, -122.415337199951) | 2 | 4 | 7 | 28859 | 19 | |||
8863 | 224037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4136 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002973.28417 | 2101264.18156 | 37.7498394178669 | -122.432534643177 | (37.7498394178669, -122.432534643177) | 2 | 4 | 5 | 28862 | 22 | |||
8973 | 170735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1895 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6000284.32157 | 2093024.69966 | 37.7270628891409 | -122.441242066294 | (37.7270628891409, -122.441242066294) | 9 | 7 | 6 | 28861 | 25 | ||
8997 | 47687 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
9047 | 47479 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
9088 | 123748 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2015 07:10:00 AM | 15 | Width 3ft | 5995551.56394 | 2110826.65908 | 37.7756718539675 | -122.458891368973 | (37.7756718539675, -122.458891368973) | 11 | 6 | 2 | 54 | 11 | ||
9151 | 110107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4130 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430 | 2103553 | 37.7548786426579 | -122.507200765499 | (37.7548786426579, -122.507200765499) | 1 | 8 | 3 | 56 | 35 |
9156 | 73920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008409.30532 | 2108731.32076 | 37.7706492380987 | -122.414264830382 | (37.7706492380987, -122.414264830382) | 8 | 2 | 9 | 28853 | 19 | |||
9157 | 261444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007112 | 2095712 | 37.7348281970622 | -122.417829229388 | (37.7348281970622, -122.417829229388) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
9295 | 223587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
9542 | 261434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 383 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007317 | 2095771 | 37.7350017327518 | -122.417124650781 | (37.7350017327518, -122.417124650781) | 2 | 7 | 7 | 28859 | 2 | ||||
9588 | 144974 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990690 | 2111380 | 37.7769105282448 | -122.475748963166 | (37.7769105282448, -122.475748963166) | 11 | 6 | 2 | 54 | 26 | ||
9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 | |||
9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
9689 | 63382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.7350757572483 | -122.41914443544 | (37.7350757572483, -122.41914443544) | 2 | 7 | 7 | 28859 | 2 | ||
9725 | 31671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1435 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | 11 | Permit Number 35179 | 6007129.43317 | 2116257.26195 | 37.7912416742097 | -122.419225877479 | (37.7912416742097, -122.419225877479) | 13 | 9 | 10 | 28858 | 21 | |
9764 | 150815 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013813.37874 | 2104087.70708 | 37.7582009725247 | -122.395246594574 | (37.7582009725247, -122.395246594574) | 10 | 3 | 8 | 28856 | 29 | |||
9952 | 148016 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002451.59987 | 2088819.6954 | 37.7156401042879 | -122.433449457832 | (37.7156401042879, -122.433449457832) | 9 | 7 | 6 | 28861 | 5 | |||
9989 | 176265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004683.74002 | 2091261.8142 | 37.7224720200432 | -122.425907897826 | (37.7224720200432, -122.425907897826) | 9 | 7 | 6 | 28861 | 5 | |||
10016 | 261433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007343 | 2095769 | 37.7349977038172 | -122.417034617662 | (37.7349977038172, -122.417034617662) | 2 | 7 | 7 | 28859 | 2 | ||||
10065 | 223575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007323 | 2098000 | 37.7411224122402 | -122.417261809722 | (37.7411224122402, -122.417261809722) | 2 | 7 | 7 | 28859 | 2 | |||
10072 | 223589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008529.06402 | 2096927.29731 | 37.7382447851783 | -122.413015832133 | (37.7382447851783, -122.413015832133) | 10 | 7 | 7 | 28859 | 2 | |||
10256 | 68236 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1515 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 9 | Permit Number 32031 | 5990787.04658 | 2113362.94185 | 37.7823607651124 | -122.475558077431 | (37.7823607651124, -122.475558077431) | 11 | 6 | 2 | 54 | 26 | |
10285 | 64550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1407 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 9 | Permit Number 25433 | 6015557.9064 | 2094994.5115 | 37.7333298097375 | -122.388578480063 | (37.7333298097375, -122.388578480063) | 10 | 3 | 8 | 58 | 1 | |
10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
10433 | 189238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2126 24th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | 10 | 3 | 8 | 28856 | 29 | |||
10631 | 106353 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520X 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006283 | 2100840 | 37.7488618444312 | -122.421059362487 | (37.7488618444312, -122.421059362487) | 2 | 4 | 5 | 28859 | 19 | |||
10646 | 172228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 203 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002933 | 2092317 | 37.7252702278754 | -122.432035115452 | (37.7252702278754, -122.432035115452) | 9 | 7 | 6 | 28861 | 5 | |||
10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
10751 | 170656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000839.66357 | 2092572.31066 | 37.7258523512861 | -122.439289849442 | (37.7258523512861, -122.439289849442) | 9 | 7 | 6 | 28861 | 25 | ||
10902 | 259838 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1997 12:00:00 AM | 3 | Permit Number 38009 | 5996907.65838 | 2089596.01103 | 37.7174555905703 | -122.452667732297 | (37.7174555905703, -122.452667732297) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
10976 | 262163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
11087 | 122015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1799 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990132.5051 | 2110630.33529 | 37.7748198185001 | -122.477622678128 | (37.7748198185001, -122.477622678128) | 11 | 6 | 2 | 55 | 26 | |||
11137 | 46998 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
11167 | 78311 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002171.16475 | 2090137.23408 | 37.7192418585039 | -122.434512917837 | (37.7192418585039, -122.434512917837) | 9 | 7 | 6 | 28861 | 5 | |||
11395 | 69965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5992352.53877 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | 11 | 6 | 2 | 54 | 11 | |||
11488 | 71394 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6015490.02353 | 2096504.22569 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | 10 | 3 | 8 | 58 | 1 | |||
11545 | 261446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007068 | 2095792 | 37.7350453831972 | -122.417987022359 | (37.7350453831972, -122.417987022359) | 2 | 7 | 7 | 28859 | 2 | ||||
11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
11677 | 26000 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007034 | (37.7359081801195, -122.39281007034) | 10 | 3 | 8 | 58 | 1 | ||
11678 | 262547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
11695 | 32589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.7631295295897 | -122.493148331917 | (37.7631295295897, -122.493148331917) | 1 | 8 | 3 | 56 | 35 | |
11818 | 207596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994790.18426 | 2091971.80036 | 37.7238573834024 | -122.460158838768 | (37.7238573834024, -122.460158838768) | 9 | 8 | 4 | 28861 | 24 | |||
11823 | 223370 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.422231628499 | (37.7602393183104, -122.422231628499) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
11903 | 73567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6015475.76559 | 2096515.71199 | 37.7375021654981 | -122.388968635992 | (37.7375021654981, -122.388968635992) | 10 | 3 | 8 | 58 | 1 | |||
12028 | 261519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:20:00 PM | Width 4ft | 5982910.9702 | 2111318.38005 | 37.7762872714849 | -122.502653994406 | (37.7762872714849, -122.502653994406) | 11 | 6 | 2 | 55 | 26 | |||
12056 | 207640 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.90266 | 2104824.95669 | 37.7589974714712 | -122.47017288688 | (37.7589974714712, -122.47017288688) | 1 | 8 | 4 | 56 | 12 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
12160 | 170683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2020 12:00:00 AM | 3 | Width 3ft | 6000666.46145 | 2092693.59381 | 37.7261755091709 | -122.439897287525 | (37.7261755091709, -122.439897287525) | 9 | 7 | 6 | 28861 | 25 | ||
12360 | 38902 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 276 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 5 | Permit Number 40716 | 5997044.32666189 | 2112582.61364036 | 37.780578937997 | -122.453854397363 | (37.780578937997, -122.453854397363) | 11 | 6 | 2 | 54 | 16 | |
12361 | 61778 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2219 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 13 | Permit Number 21799 | 6011858.65617 | 2102307.02304 | 37.7532027015499 | -122.401881742259 | (37.7532027015499, -122.401881742259) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
12399 | 55507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1986 12:00:00 AM | 20 | Permit Number 23375 | 6004977.3709 | 2119202.3279 | 37.7992066440205 | -122.426881792584 | (37.7992066440205, -122.426881792584) | 13 | 9 | 1 | 57 | 17 | |
12550 | 63379 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 311 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23959 | 6006965.60744401 | 2095790.54383517 | 37.7350356215507 | -122.418340927554 | (37.7350356215507, -122.418340927554) | 2 | 7 | 7 | 28859 | 2 | ||
12755 | 214559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1342 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | 11 | 8 | 11 | 56 | 12 | ||
12812 | 170654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000891.32853 | 2092534.3103 | 37.7257509509219 | -122.439108525449 | (37.7257509509219, -122.439108525449) | 9 | 7 | 6 | 28861 | 25 | ||
12861 | 253706 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
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 | ||
13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
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 | ||||
13251 | 262414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6003118 | 2094425 | 37.7310688083977 | -122.431546013106 | (37.7310688083977, -122.431546013106) | 9 | 7 | 5 | 28861 | 25 | |
13393 | 207553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993922.26035 | 2106313.56882 | 37.7631863112193 | -122.464199775125 | (37.7631863112193, -122.464199775125) | 1 | 5 | 11 | 56 | 12 | |||
13425 | 223490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.30011 | 2107940.39716 | 37.768488553924 | -122.41353093232 | (37.768488553924, -122.41353093232) | 8 | 4 | 7 | 28853 | 19 | |||
13516 | 90326 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989640.77384 | 2111238.69513 | 37.7764616586133 | -122.479368175716 | (37.7764616586133, -122.479368175716) | 11 | 6 | 2 | 55 | 26 | ||
13567 | 243284 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | 8 | 4 | 7 | 28853 | 19 | |
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 | ||
13864 | 38641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | 4x10 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931 | (37.7308498822776, -122.39056651931) | 10 | 3 | 8 | 58 | 1 |
13899 | 223627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006726 | 2101710 | 37.7512756289395 | -122.419589182986 | (37.7512756289395, -122.419589182986) | 2 | 4 | 7 | 28859 | 19 | |||
14053 | 62766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1988 12:00:00 AM | Permit Number 25290 | 5993348.39587904 | 2103942.72221653 | 37.7566434919089 | -122.466012277578 | (37.7566434919089, -122.466012277578) | 1 | 8 | 4 | 56 | 12 | ||
14055 | 90182 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990417.75212 | 2111322.65396 | 37.7767372842601 | -122.476686550978 | (37.7767372842601, -122.476686550978) | 11 | 6 | 2 | 55 | 26 | ||
14120 | 11922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 |
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) );