trees
294 rows where Police Districts = 4 and qSpecies_id = 53 sorted by Neighborhoods (old) descending
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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 7359 | 121255 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 283 Dorland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003780 | 2105549 | 37.7616502297697 | -122.430050607682 | (37.7616502297697, -122.430050607682) | 8 | 4 | 5 | 28862 | 3 | ||||
| 11498 | 115743 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 28 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
| 17055 | 104825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003350 | 2106266 | 37.7635945765505 | -122.431588992909 | (37.7635945765505, -122.431588992909) | 15 | 4 | 5 | 28862 | 3 | |||
| 24098 | 50784 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4425@ EUREKA 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2004 12:00:00 AM | Permit Number 47310 | 6001319.3692016 | 2105218.84665198 | 37.760604043869 | -122.438537258087 | (37.760604043869, -122.438537258087) | 2 | 4 | 5 | 28862 | 3 | |||
| 32408 | 54027 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778679 | 6004696.3346429 | 2103995.33974478 | 37.7574361004301 | -122.426770728763 | (37.7574361004301, -122.426770728763) | 2 | 4 | 5 | 28862 | 3 | |
| 32730 | 5389 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 330X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6004827.24095 | 2106401.30238 | 37.7640497043733 | -122.426489313449 | (37.7640497043733, -122.426489313449) | 8 | 4 | 5 | 28859 | 3 | |||
| 51694 | 173776 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
| 59221 | 48449 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1971 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | Permit Number 45821 | 6004348.70626507 | 2107156.39257844 | 37.7660959373339 | -122.428198241647 | (37.7660959373339, -122.428198241647) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 64331 | 5481 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
| 72782 | 58078 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4624 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | Permit Number 17049 | 6000401 | 2105218 | 37.7605494356876 | -122.441713410467 | (37.7605494356876, -122.441713410467) | 15 | 4 | 5 | 28862 | 3 | |||
| 78708 | 120673 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3876 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003780.8 | 2105549.3 | 37.761651098806 | -122.430047862208 | (37.761651098806, -122.430047862208) | 8 | 4 | 5 | 28862 | 3 | ||||
| 81846 | 61476 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1942 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1984 12:00:00 AM | 20 | 4x3 | Permit Number 21419 | 6004543.5 | 2107230.3 | 37.7663098890238 | -122.427529754413 | (37.7663098890238, -122.427529754413) | 8 | 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 | |||
| 87381 | 5388 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 330X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6004825.95108 | 2106424.13775 | 37.7641123319355 | -122.426495400824 | (37.7641123319355, -122.426495400824) | 8 | 4 | 5 | 28859 | 3 | |||
| 87589 | 121254 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 283 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003780 | 2105549 | 37.7616502297697 | -122.430050607682 | (37.7616502297697, -122.430050607682) | 8 | 4 | 5 | 28862 | 3 | ||||
| 97800 | 115748 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 6 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 24 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
| 103761 | 121256 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 283 Dorland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003780 | 2105549 | 37.7616502297697 | -122.430050607682 | (37.7616502297697, -122.430050607682) | 8 | 4 | 5 | 28862 | 3 | ||||
| 106391 | 115747 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 5 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 16 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
| 107245 | 58071 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4545 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | 13 | Permit Number 17041 | 6000791.5456109 | 2105188.83821507 | 37.7604916091053 | -122.440360603481 | (37.7604916091053, -122.440360603481) | 2 | 4 | 5 | 28862 | 3 | ||
| 107985 | 115744 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 24 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
| 111149 | 53710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4067 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1970 12:00:00 AM | 14 | Permit Number 6657 | 6002578.30950532 | 2104703.42856113 | 37.7592603634983 | -122.434146313573 | (37.7592603634983, -122.434146313573) | 2 | 4 | 5 | 28862 | 3 | ||
| 112309 | 115745 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 20 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
| 112589 | 115746 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 28 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
| 112940 | 106936 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 98X EUREKA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x5 | 6001388 | 2105433 | 37.7611959604452 | -122.438315238354 | (37.7611959604452, -122.438315238354) | 15 | 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 | |||
| 114066 | 54117 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4356 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 3x3 | Permit Number 52105 | 6001531.81835159 | 2105282.89107801 | 37.7607919769606 | -122.437807081492 | (37.7607919769606, -122.437807081492) | 15 | 4 | 5 | 28862 | 3 | ||
| 120227 | 96963 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3401X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | 6004198 | 2106595 | 37.7645459600586 | -122.428679481968 | (37.7645459600586, -122.428679481968) | 8 | 4 | 5 | 28862 | 3 | |||
| 122961 | 53708 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 350 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1970 12:00:00 AM | 36 | Permit Number 6655 | 6003550.85725641 | 2106242.74617004 | 37.7635421097395 | -122.430892631532 | (37.7635421097395, -122.430892631532) | 15 | 4 | 5 | 28862 | 3 | ||
| 123770 | 5390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 330X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6004823.7091277 | 2106419.4754114 | 37.7640994035261 | -122.426502823086 | (37.7640994035261, -122.426502823086) | 8 | 4 | 5 | 28859 | 3 | |||
| 131463 | 120674 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3876 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003780.8 | 2105549.3 | 37.761651098806 | -122.430047862208 | (37.761651098806, -122.430047862208) | 8 | 4 | 5 | 28862 | 3 | ||||
| 140006 | 173777 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
| 149401 | 55522 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | Permit Number 11483 | 6003594.27279224 | 2105459.16759406 | 37.7613930510814 | -122.430686551957 | (37.7613930510814, -122.430686551957) | 15 | 4 | 5 | 28862 | 3 | |||
| 152209 | 105842 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 51 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2x3 | 6003352 | 2106231 | 37.7634985883576 | -122.431579576657 | (37.7634985883576, -122.431579576657) | 15 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 158811 | 225015 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.82559 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | 2 | 4 | 5 | 28862 | 3 | |
| 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 | |||
| 166702 | 57580 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 6 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1976 12:00:00 AM | 10 | Permit Number 16447 | 6003825.41823987 | 2107112.36179244 | 37.7659454174839 | -122.430005049505 | (37.7659454174839, -122.430005049505) | 8 | 4 | 5 | 28862 | 3 | ||
| 176391 | 55727 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2153 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | Permit Number 11753 | 6003484.39561577 | 2107108.612602 | 37.7659158038039 | -122.431184308511 | (37.7659158038039, -122.431184308511) | 15 | 4 | 5 | 28862 | 3 | |||
| 180301 | 96962 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3401X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | 6004198 | 2106595 | 37.7645459600586 | -122.428679481968 | (37.7645459600586, -122.428679481968) | 8 | 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 | ||||
| 189703 | 66879 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.7592879918503 | -122.439106757133 | (37.7592879918503, -122.439106757133) | 2 | 4 | 5 | 28862 | 3 | ||
| 190159 | 225029 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.440353514511 | (37.7605181908718, -122.440353514511) | 2 | 4 | 5 | 28862 | 3 | |
| 193673 | 120592 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3773 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003806 | 2105923 | 37.7626786166025 | -122.429987363922 | (37.7626786166025, -122.429987363922) | 8 | 4 | 5 | 28862 | 3 | ||||
| 193861 | 44757 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43870 | 6003593.00847933 | 2105481.98628904 | 37.7614556341181 | -122.430692553071 | (37.7614556341181, -122.430692553071) | 15 | 4 | 5 | 28862 | 3 | ||||
| 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 | ||||
| 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 | ||||
| 44231 | 57108 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.7520879863161 | -122.426451960244 | (37.7520879863161, -122.426451960244) | 2 | 4 | 5 | 28862 | 22 | |
| 53386 | 55163 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1328 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | Permit Number 31912 | 6002514.24849197 | 2101716.89965545 | 37.751056432833 | -122.434154367056 | (37.751056432833, -122.434154367056) | 2 | 4 | 5 | 28862 | 22 | |||
| 61113 | 57802 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.7532392091702 | -122.440756591601 | (37.7532392091702, -122.440756591601) | 2 | 4 | 5 | 28862 | 22 | |
| 61535 | 5622 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1202 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005101.96034 | 2101291.72603 | 37.7500355321086 | -122.425175538874 | (37.7500355321086, -122.425175538874) | 2 | 4 | 5 | 28862 | 22 | |||
| 63433 | 4418 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004420.05713 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 69799 | 59060 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4437 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1992 12:00:00 AM | 14 | 2x2 | Permit Number 30882 | 6000423.21385776 | 2102243.23045707 | 37.7523827100743 | -122.441423120737 | (37.7523827100743, -122.441423120737) | 2 | 4 | 5 | 28862 | 22 | |
| 102319 | 61449 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330-1332 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1984 12:00:00 AM | Permit Number 21384 | 6002514.93546023 | 2101705.58374617 | 37.7510254010171 | -122.434151182595 | (37.7510254010171, -122.434151182595) | 2 | 4 | 5 | 28862 | 22 | |||
| 103514 | 4559 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 10x6 | 6005144.0595933 | 2101075.0968609 | 37.7494430966122 | -122.425014546007 | (37.7494430966122, -122.425014546007) | 2 | 4 | 5 | 28862 | 22 | |||
| 115017 | 4281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | 2 | 4 | 5 | 63 | 22 | |||
| 124546 | 5589 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005080.54834 | 2102051.49498 | 37.7521204720239 | -122.425303641737 | (37.7521204720239, -122.425303641737) | 2 | 4 | 5 | 28862 | 22 | |||
| 125904 | 57425 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/1976 12:00:00 AM | 20 | 6x10 | Permit Number 16267 | 6004690.36073914 | 2101363.26470881 | 37.750208699936 | -122.426603966833 | (37.750208699936, -122.426603966833) | 2 | 4 | 5 | 28862 | 22 | |
| 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 | |||
| 139096 | 51485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 253 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2005 12:00:00 AM | Permit Number 47796 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | 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 | ||||
| 152624 | 4455 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1404 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/13/2015 12:00:00 AM | 70 | 3X3 | 6004493.5375 | 2100668.30282 | 37.7482893665971 | -122.427235096559 | (37.7482893665971, -122.427235096559) | 2 | 4 | 5 | 63 | 22 | ||
| 155520 | 58902 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 15 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1980 12:00:00 AM | Permit Number 18176 | 6005036.25199829 | 2101622.63318287 | 37.7509404143338 | -122.425426308198 | (37.7509404143338, -122.425426308198) | 2 | 4 | 5 | 28862 | 22 | |||
| 159337 | 98224 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4068 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2012 12:00:00 AM | 3x3 | Permit Number 56734 | 6003417.8 | 2101304.1 | 37.7499742222019 | -122.431000336814 | (37.7499742222019, -122.431000336814) | 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 | |||
| 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 | |||
| 178363 | 5655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1332 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005148.4988519 | 2100582.0357256 | 37.7480895150856 | -122.424964119184 | (37.7480895150856, -122.424964119184) | 2 | 4 | 5 | 63 | 22 | |||
| 181736 | 5595 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005095.5235026 | 2101950.1341989 | 37.7518430048639 | -122.425244643333 | (37.7518430048639, -122.425244643333) | 2 | 4 | 5 | 28862 | 22 | |||
| 192632 | 5633 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | 2 | 4 | 5 | 28862 | 22 | |||
| 140677 | 68840 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1506 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | Permit Number 32793 | 6009553.56622839 | 2100554.07443475 | 37.7482605801949 | -122.4097295193 | (37.7482605801949, -122.4097295193) | 2 | 4 | 7 | 28859 | 2 | |||
| 8209 | 103628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
| 8269 | 99967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 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 | |||
| 16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 19799 | 661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
| 20262 | 253597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010453 | 2107072 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | 8 | 4 | 8 | 28853 | 19 | ||||
| 20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
| 20430 | 647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 | |||
| 24151 | 96336 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.7661454629436 | -122.42523686393 | (37.7661454629436, -122.42523686393) | 8 | 4 | 5 | 28853 | 19 | |||
| 24579 | 96732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 514 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007319.4 | 2106562.9 | 37.7646339820142 | -122.417881101898 | (37.7646339820142, -122.417881101898) | 8 | 4 | 7 | 28859 | 19 | |||
| 24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
| 26891 | 601 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6008510.8606794 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | 2 | 4 | 7 | 28859 | 19 | ||||
| 28577 | 18320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 206 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010262.2750436 | 2107350.6845554 | 37.7669622387245 | -122.40775798639 | (37.7669622387245, -122.40775798639) | 8 | 4 | 8 | 28853 | 19 | |||
| 29857 | 57300 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3178 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | 14 | 3x3 | Permit Number 16122 | 6005671.4432239 | 2106688.52693537 | 37.7648860421109 | -122.423589884437 | (37.7648860421109, -122.423589884437) | 8 | 4 | 5 | 28853 | 19 | |
| 29987 | 578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008810.60715 | 2102251.62423 | 37.7528800095792 | -122.412418632597 | (37.7528800095792, -122.412418632597) | 2 | 4 | 7 | 28859 | 19 | |||
| 31123 | 18463 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
| 32305 | 173934 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||||
| 33185 | 18322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 226 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010268.7839855 | 2107259.8540962 | 37.7667132034185 | -122.407729067657 | (37.7667132034185, -122.407729067657) | 8 | 4 | 8 | 28853 | 19 | |||
| 33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
| 34217 | 575 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.7524549543286 | -122.41222072227 | (37.7524549543286, -122.41222072227) | 2 | 4 | 7 | 28859 | 19 | |||
| 35179 | 95222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299 on 16th St Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004880 | 2106610 | 37.7646257206218 | -122.426321695151 | (37.7646257206218, -122.426321695151) | 8 | 4 | 5 | 28859 | 19 | |||
| 37666 | 646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 40407 | 668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 |
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) );