trees
294 rows where Police Districts = 4 and qSpecies_id = 53 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 57818 | 111388 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | |||
| 58860 | 111391 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 62309 | 111394 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 99259 | 111393 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 148285 | 111389 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 189307 | 111392 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 192675 | 111390 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 73104 | 5386 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 325X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
| 93022 | 5387 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 325X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 114328 | 50197 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3279@ DOLORES 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2003 12:00:00 AM | Permit Number 46903 | 6005006.02996154 | 2106599.52754391 | 37.7646040888867 | -122.425885045341 | (37.7646040888867, -122.425885045341) | 8 | 4 | 5 | 28859 | 19 | ||
| 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 | |||
| 51820 | 12942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 188704 | 57306 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3265 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 5.5x9 | Permit Number 30983 | 6005094.29272651 | 2106604.42467206 | 37.7646225228273 | -122.425580116407 | (37.7646225228273, -122.425580116407) | 8 | 4 | 5 | 28859 | 19 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 43367 | 116602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x9 | 6005124 | 2106632 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 56472 | 96337 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 2 | 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 | |||
| 44509 | 60715 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 30 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | 24 | 3x3 | Permit Number 20368 | 6005215.9296478 | 2105282.4178358 | 37.7609994776864 | -122.425065336381 | (37.7609994776864, -122.425065336381) | 2 | 4 | 5 | 28859 | 19 | |
| 165318 | 93031 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3265 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5.5x9 | 6005231 | 2106625 | 37.7646867413409 | -122.425108746155 | (37.7646867413409, -122.425108746155) | 8 | 4 | 5 | 28859 | 19 | |||
| 177096 | 51793 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2005 12:00:00 AM | Permit Number 48042 | 6005279.64463313 | 2105087.60921781 | 37.7604681781651 | -122.42483111417 | (37.7604681781651, -122.42483111417) | 2 | 4 | 5 | 28859 | 19 | |||
| 139295 | 59013 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3755 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1980 12:00:00 AM | 20 | Permit Number 18304 | 6005291.98683548 | 2104267.80164023 | 37.7582178764875 | -122.424730106513 | (37.7582178764875, -122.424730106513) | 2 | 4 | 5 | 28859 | 19 | ||
| 173374 | 98862 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 25 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005344.6 | 2105317.5 | 37.7611030726424 | -122.424622816907 | (37.7611030726424, -122.424622816907) | 2 | 4 | 5 | 28859 | 19 | ||||
| 171840 | 69122 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3744 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1994 12:00:00 AM | 22 | 5x9 | Permit Number 33140 | 6005352.36529805 | 2104323.23161765 | 37.7583734841408 | -122.424525234112 | (37.7583734841408, -122.424525234112) | 2 | 4 | 5 | 28859 | 19 | |
| 120502 | 57735 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 364 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 16 | Permit Number 31982 | 6005454.9599493 | 2101588.78174199 | 37.7508711140338 | -122.423975967283 | (37.7508711140338, -122.423975967283) | 2 | 4 | 5 | 28859 | 19 | ||
| 132426 | 95220 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3208 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005461 | 2106663 | 37.7648040703693 | -122.424315938973 | (37.7648040703693, -122.424315938973) | 8 | 4 | 5 | 28853 | 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 | |||
| 162339 | 10147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 940 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005660.7422371 | 2103489.3240903 | 37.7561011788947 | -122.423399446987 | (37.7561011788947, -122.423399446987) | 2 | 4 | 5 | 28859 | 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 | |
| 60087 | 86905 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775 | 2106383 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | 8 | 4 | 5 | 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) );