trees
451 rows where qLegalStatus_id = 4 and qSpecies_id = 53 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4983 | 112267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11335 | 112269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18422 | 112268 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
112578 | 112394 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000472 | 2089324 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | 9 | 7 | 6 | 28861 | 5 | ||||
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
146767 | 119279 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
57261 | 111200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 801x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | ||||
52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
89965 | 116128 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
163580 | 116126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
174144 | 116127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
89944 | 108971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 20x ROUSSEAU ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003466 | 2095297.3 | 37.7334836652593 | -122.430405132046 | (37.7334836652593, -122.430405132046) | 2 | 7 | 5 | 28861 | 25 | ||||
166856 | 95409 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Added tree to database on 2/28/11. Appears to be 15-20 yrs old. | 6002410 | 2095371 | 37.7336261540057 | -122.434061286386 | (37.7336261540057, -122.434061286386) | 2 | 7 | 5 | 63 | 7 | ||
140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
181257 | 109235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002570.3 | 2095716.9 | 37.7345850124828 | -122.433531794387 | (37.7345850124828, -122.433531794387) | 2 | 7 | 5 | 63 | 7 | ||||
142768 | 112396 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 574 VALLEY ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002248 | 2099192 | 37.7441085392299 | -122.434894531673 | (37.7441085392299, -122.434894531673) | 2 | 7 | 5 | 63 | 22 | ||||
19076 | 99594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
122922 | 99595 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
79797 | 113702 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 14 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
110718 | 113188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x12 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
152427 | 112646 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3101 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008718 | 2100791 | 37.7488642652044 | -122.412635640211 | (37.7488642652044, -122.412635640211) | 2 | 4 | 7 | 28859 | 19 | |||
168783 | 96335 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3705 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 28622 | 6005781 | 2101380 | 37.7503162492489 | -122.422833652647 | (37.7503162492489, -122.422833652647) | 2 | 4 | 5 | 28859 | 19 | ||
43227 | 110731 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
54160 | 110730 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
125549 | 110733 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
190351 | 110732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
93776 | 110724 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
95408 | 110726 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
95901 | 110725 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
115099 | 110727 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
123934 | 110723 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | |||
93614 | 109925 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 375 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6005525.2 | 2101540.6 | 37.7507427833765 | -122.423729644924 | (37.7507427833765, -122.423729644924) | 2 | 4 | 5 | 28859 | 19 | |||
41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
10358 | 120965 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
43513 | 120964 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
140782 | 120966 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
175062 | 97110 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1095X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003193.9 | 2101874 | 37.751526344012 | -122.431815280512 | (37.751526344012, -122.431815280512) | 2 | 4 | 5 | 28862 | 22 | |||
172156 | 97109 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1095X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003187 | 2102045 | 37.7519954785262 | -122.431851350128 | (37.7519954785262, -122.431851350128) | 2 | 4 | 5 | 28862 | 22 | |||
18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
138560 | 121561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1044 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003754 | 2102206 | 37.7524696725481 | -122.429902065263 | (37.7524696725481, -122.429902065263) | 2 | 4 | 5 | 28862 | 22 | |||
56222 | 121122 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
64233 | 121118 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
77226 | 121119 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
106064 | 121117 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
131499 | 121120 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
151070 | 121123 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
127066 | 96913 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 65X Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005919.1 | 2102263.8 | 37.7527507518094 | -122.422418882903 | (37.7527507518094, -122.422418882903) | 2 | 4 | 5 | 28859 | 19 | ||||
8959 | 113224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001623 | 2102374 | 37.7528100494278 | -122.437283434624 | (37.7528100494278, -122.437283434624) | 2 | 4 | 5 | 28862 | 22 | ||||
28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
130690 | 109005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
140999 | 109004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
141541 | 109003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
66076 | 112051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3748x 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003448 | 2103060 | 37.7547972209553 | -122.431021210073 | (37.7547972209553, -122.431021210073) | 2 | 4 | 5 | 28862 | 22 | |||
99827 | 109850 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3250x 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
155548 | 115216 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 3x3 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | ||
4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
113469 | 117124 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
106094 | 117567 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2498 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008843 | 2103923 | 37.7574710478396 | -122.41242474225 | (37.7574710478396, -122.41242474225) | 2 | 4 | 7 | 28859 | 19 | |||
63978 | 119667 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 699x Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
60853 | 97999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
85172 | 98001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
97918 | 102451 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | |||
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
64858 | 102457 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
119605 | 102455 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
133761 | 102454 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
71888 | 102035 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2400 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008197 | 2104472 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | 2 | 4 | 7 | 28859 | 19 | |||
139754 | 98643 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2391 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008222 | 2104509 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | 2 | 4 | 7 | 28859 | 19 | |||
163561 | 101313 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 14 | 5x6 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
138351 | 107659 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1324 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5999078.1 | 2104991.6 | 37.759852333413 | -122.446272413537 | (37.759852333413, -122.446272413537) | 15 | 5 | 5 | 28862 | 3 | |||
135877 | 109331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1325 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
18675 | 101715 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
54784 | 101716 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
87085 | 101725 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
105989 | 101717 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
138070 | 101722 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
138887 | 101721 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
143637 | 101724 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
158929 | 101720 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
169319 | 101719 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
176915 | 101718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
179159 | 101726 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
56413 | 111223 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
61037 | 111219 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
110191 | 111226 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
135014 | 111218 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
142406 | 111224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
188189 | 111222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
155693 | 110274 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4624 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6000413 | 2105241 | 37.7606132717498 | -122.4416735587 | (37.7606132717498, -122.4416735587) | 15 | 4 | 5 | 28862 | 3 |
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) );