trees
1,194 rows where qSpecies_id = 50 sorted by Fire Prevention Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11283 | 96093 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Drake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481 | 2086737 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | 9 | 7 | 6 | 28861 | 5 | ||
| 14147 | 219232 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 393 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994163.921 | 2092422.70166 | 37.7250594073463 | -122.462356400531 | (37.7250594073463, -122.462356400531) | 9 | 8 | 4 | 28861 | 40 | |||
| 22913 | 96092 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481 | 2086737 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | 9 | 7 | 6 | 28861 | 5 | ||
| 33999 | 219234 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 273 Dalewood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995327.0897 | 2097229.75541 | 37.7383253194549 | -122.458683321089 | (37.7383253194549, -122.458683321089) | 9 | 7 | 4 | 59 | 40 | |||
| 47608 | 176585 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Seneca Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5999821.59853 | 2090369.86807 | 37.719746961831 | -122.442651149242 | (37.719746961831, -122.442651149242) | 9 | 7 | 6 | 28861 | 25 | |||
| 104885 | 176588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 151 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004383.65032 | 2094057.63554 | 37.73013176266 | -122.427144283984 | (37.73013176266, -122.427144283984) | 9 | 7 | 6 | 28861 | 5 | |||
| 108539 | 219235 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 5 Sequoia Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998215.18129 | 2097817.79881 | 37.7401055166597 | -122.448740104476 | (37.7401055166597, -122.448740104476) | 9 | 7 | 4 | 59 | 40 | |||
| 128376 | 46610 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 90 Stoneybrook Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44733 | 6005754.19470514 | 2093788.76212956 | 37.7294709047894 | -122.422387032926 | (37.7294709047894, -122.422387032926) | 9 | 7 | 6 | 28861 | 5 | |||
| 157433 | 176584 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 263 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5997986.0041 | 2088216.93337 | 37.7137306897928 | -122.448841125323 | (37.7137306897928, -122.448841125323) | 9 | 7 | 6 | 28861 | 25 | |||
| 157876 | 111096 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 15 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||
| 174816 | 96091 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481 | 2086737 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | 9 | 7 | 6 | 28861 | 5 | ||
| 175730 | 254646 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Saint Charles Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 3x3 | 5992096 | 2088072 | 37.7129941473192 | -122.469188407447 | (37.7129941473192, -122.469188407447) | 9 | 8 | 6 | 64 | 24 | |||
| 177270 | 176586 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Seneca Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999824.12192 | 2090353.83878 | 37.7197030929005 | -122.442641276491 | (37.7197030929005, -122.442641276491) | 9 | 7 | 6 | 28861 | 25 | |||
| 187580 | 219233 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 387 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994164.56547 | 2092392.43636 | 37.7249763432778 | -122.462351978558 | (37.7249763432778, -122.462351978558) | 9 | 8 | 4 | 28861 | 40 | |||
| 991 | 38251 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | 8 | 4 | 7 | 28853 | 19 | ||
| 1652 | 243315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 40 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006628.53628 | 2105662.75814 | 37.7621234987325 | -122.420206730272 | (37.7621234987325, -122.420206730272) | 8 | 4 | 7 | 28859 | 19 | |||
| 2118 | 73083 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.418411696436 | (37.7635727856768, -122.418411696436) | 8 | 4 | 7 | 28859 | 19 | ||
| 2489 | 224583 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008562.45401 | 2106796.83945 | 37.7653462039852 | -122.413598242063 | (37.7653462039852, -122.413598242063) | 8 | 4 | 7 | 28859 | 19 | |
| 3670 | 229792 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | 8 | 4 | 7 | 28853 | 19 | |||
| 5058 | 228531 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009451.25319 | 2106552.40785 | 37.7647249190387 | -122.410506818932 | (37.7647249190387, -122.410506818932) | 8 | 4 | 7 | 28859 | 19 | |||
| 8056 | 224581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008597.08192 | 2106800.15076 | 37.7653572404576 | -122.413478706001 | (37.7653572404576, -122.413478706001) | 8 | 4 | 7 | 28859 | 19 | |
| 9710 | 239955 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3448 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | 2x3 | Permit Number 50576 | 6006541.34834 | 2105555.19292 | 37.7618232366876 | -122.420500644884 | (37.7618232366876, -122.420500644884) | 8 | 4 | 7 | 28859 | 19 | |
| 9980 | 110373 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
| 10242 | 52219 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
| 11549 | 70665 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 550 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010647.04803 | 2105639.57925 | 37.7622854639243 | -122.406306536234 | (37.7622854639243, -122.406306536234) | 8 | 4 | 8 | 28859 | 19 | |||
| 11638 | 95638 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462 | 2107407 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | 8 | 4 | 5 | 28862 | 3 | |
| 12120 | 70682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010606.08274 | 2106339.87511 | 37.7642060264098 | -122.406497569303 | (37.7642060264098, -122.406497569303) | 8 | 4 | 8 | 28859 | 19 | |||
| 12723 | 229788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005571.35245 | 2107231.70655 | 37.7663718340174 | -122.423974702579 | (37.7663718340174, -122.423974702579) | 8 | 4 | 5 | 28853 | 19 | |||
| 13570 | 34057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | 8 | 4 | 7 | 28859 | 19 | ||
| 14471 | 70661 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 460 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010614.613 | 2106160.28585 | 37.7637133921776 | -122.40645540999 | (37.7637133921776, -122.40645540999) | 8 | 4 | 8 | 28859 | 19 | |||
| 14632 | 224584 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.413665425938 | (37.76534068665, -122.413665425938) | 8 | 4 | 7 | 28859 | 19 | |
| 15198 | 70134 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 342-344 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010584.92199 | 2106684.72003 | 37.7651517084965 | -122.406595061225 | (37.7651517084965, -122.406595061225) | 8 | 4 | 8 | 28853 | 19 | |||
| 15488 | 228530 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6009448.17881 | 2106596.433 | 37.7648456296528 | -122.410520561485 | (37.7648456296528, -122.410520561485) | 8 | 4 | 7 | 28859 | 19 | |||
| 19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
| 19464 | 224582 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008579.87348 | 2106797.48808 | 37.7653489631036 | -122.413538037855 | (37.7653489631036, -122.413538037855) | 8 | 4 | 7 | 28859 | 19 | |
| 20654 | 37663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 12 | 6x6 | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 |
| 20883 | 229739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | 8 | 4 | 5 | 28859 | 19 | |||
| 21203 | 190740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010535.58814 | 2107583.98443 | 37.7676181235051 | -122.406829079197 | (37.7676181235051, -122.406829079197) | 8 | 4 | 8 | 28853 | 19 | |||
| 26670 | 226355 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2175 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008795.60516 | 2105650.73446 | 37.7622123526471 | -122.412710792894 | (37.7622123526471, -122.412710792894) | 8 | 4 | 7 | 28859 | 19 | |||
| 27550 | 228526 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.70378 | 2106296.28434 | 37.7640099687976 | -122.411210045617 | (37.7640099687976, -122.411210045617) | 8 | 4 | 7 | 28859 | 19 | |||
| 28802 | 226329 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007821.99816 | 2105868.63243 | 37.7627559568505 | -122.416093572069 | (37.7627559568505, -122.416093572069) | 8 | 4 | 7 | 28859 | 19 | |||
| 29366 | 36052 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
| 29685 | 190682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010644.58891 | 2105668.45784 | 37.7623646204591 | -122.406317076288 | (37.7623646204591, -122.406317076288) | 8 | 4 | 8 | 28859 | 19 | |||
| 30663 | 190724 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2277 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010411.73546 | 2107844.78326 | 37.7683272866084 | -122.407275858794 | (37.7683272866084, -122.407275858794) | 8 | 4 | 8 | 28853 | 19 | |||
| 32924 | 190747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011390.12769 | 2107238.80287 | 37.7667181107881 | -122.403849027209 | (37.7667181107881, -122.403849027209) | 8 | 2 | 8 | 28853 | 20 | |||
| 33145 | 226330 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007820.88393 | 2105900.22293 | 37.7628426343977 | -122.416099663169 | (37.7628426343977, -122.416099663169) | 8 | 4 | 7 | 28859 | 19 | |||
| 34711 | 44001 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 35048 | 46554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
| 35810 | 34056 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | 8 | 4 | 7 | 28859 | 19 | ||
| 37180 | 44003 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 37213 | 229796 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005429.44821 | 2105495.57142 | 37.7615968062711 | -122.42434202887 | (37.7615968062711, -122.42434202887) | 8 | 4 | 5 | 28859 | 19 | |||
| 37788 | 34059 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | 12 | 6x7 | Permit Number 37961 | 6009447.37701969 | 2106694.23265708 | 37.7651141201322 | -122.410530241296 | (37.7651141201322, -122.410530241296) | 8 | 4 | 7 | 28859 | 19 | |
| 39204 | 108736 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1351 Minna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | 8 | 4 | 7 | 28853 | 19 | ||
| 41290 | 36062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | ||
| 41443 | 108489 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 131 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773695 | 6008906.91703 | 2111099.40816 | 37.7771793890601 | -122.412711016861 | (37.7771793890601, -122.412711016861) | 8 | 2 | 9 | 28853 | 34 |
| 43209 | 39079 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2280X Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
| 43233 | 226460 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007913.34927 | 2105633.2143 | 37.7621146889646 | -122.415760949718 | (37.7621146889646, -122.415760949718) | 8 | 4 | 7 | 28859 | 19 | |||
| 43619 | 229810 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1801 Bryant St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009529.11729 | 2106277.27866 | 37.7639738421376 | -122.4102180799 | (37.7639738421376, -122.4102180799) | 8 | 4 | 8 | 28859 | 19 | |||
| 43994 | 229790 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007575.95086 | 2107340.46198 | 37.7667834204423 | -122.417048857113 | (37.7667834204423, -122.417048857113) | 8 | 4 | 7 | 28853 | 19 | |||
| 45167 | 110369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010361.75992 | 2107841.88666 | 37.7683165361048 | -122.407448516042 | (37.7683165361048, -122.407448516042) | 8 | 4 | 8 | 28853 | 19 | |||
| 45724 | 229789 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007559.60101 | 2107340.57096 | 37.7667827999232 | -122.417105416394 | (37.7667827999232, -122.417105416394) | 8 | 4 | 7 | 28853 | 19 | |||
| 46170 | 229805 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3526 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006031.82091 | 2105526.37435 | 37.7617153800751 | -122.422260852855 | (37.7617153800751, -122.422260852855) | 8 | 4 | 5 | 28859 | 19 | |||
| 48019 | 190731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010525.63223 | 2107742.12089 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | 8 | 4 | 8 | 28853 | 19 | |||
| 48475 | 226811 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004456.5508 | 2107418.49179 | 37.7668217000839 | -122.427843906179 | (37.7668217000839, -122.427843906179) | 8 | 4 | 5 | 28862 | 3 | |||
| 49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
| 51327 | 111062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 51672 | 111057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 52561 | 226312 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2180 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008090.95388 | 2105786.60151 | 37.7625458374421 | -122.4151575397 | (37.7625458374421, -122.4151575397) | 8 | 4 | 7 | 28859 | 19 | |||
| 52726 | 226462 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007188.60102 | 2106179.35089 | 37.7635734837649 | -122.418306305386 | (37.7635734837649, -122.418306305386) | 8 | 4 | 7 | 28859 | 19 | |||
| 53104 | 229794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 270 14th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.7683822351787 | -122.419295689168 | (37.7683822351787, -122.419295689168) | 8 | 4 | 7 | 28853 | 19 | |||
| 53107 | 190726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010460.27046 | 2107847.89076 | 37.7683385353269 | -122.40710819908 | (37.7683385353269, -122.40710819908) | 8 | 4 | 8 | 28853 | 19 | |||
| 57222 | 95619 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767387 | 6007152 | 2106175 | 37.7635594768753 | -122.418432588523 | (37.7635594768753, -122.418432588523) | 8 | 4 | 7 | 28859 | 19 | |
| 60589 | 226459 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3242 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007896.86765 | 2105631.29342 | 37.7621084881288 | -122.415817817459 | (37.7621084881288, -122.415817817459) | 8 | 4 | 7 | 28859 | 19 | |||
| 60733 | 36054 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
| 63833 | 190728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.7682576862591 | -122.406890823964 | (37.7682576862591, -122.406890823964) | 8 | 4 | 8 | 28853 | 19 | |||
| 64720 | 228525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.7639713843042 | -122.411209189472 | (37.7639713843042, -122.411209189472) | 8 | 4 | 7 | 28859 | 19 | |||
| 70077 | 110371 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
| 70750 | 36055 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
| 72715 | 44010 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 76015 | 190723 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2277 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010387.48096 | 2107844.66484 | 37.7683256039748 | -122.407359744866 | (37.7683256039748, -122.407359744866) | 8 | 4 | 8 | 28853 | 19 | |||
| 76063 | 226809 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003890.70666 | 2106665.10208 | 37.7647210474575 | -122.429747326692 | (37.7647210474575, -122.429747326692) | 8 | 4 | 5 | 28862 | 3 | |||
| 76307 | 229740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005206.89439 | 2105762.97862 | 37.7623184735408 | -122.425130780182 | (37.7623184735408, -122.425130780182) | 8 | 4 | 5 | 28859 | 19 | |||
| 76731 | 46556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
| 76930 | 226311 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2070 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008053.75125 | 2106490.49002 | 37.7644764615472 | -122.415336042545 | (37.7644764615472, -122.415336042545) | 8 | 4 | 7 | 28859 | 19 | |||
| 77015 | 190727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010484.13409 | 2107848.45184 | 37.7683414113517 | -122.407025696183 | (37.7683414113517, -122.407025696183) | 8 | 4 | 8 | 28853 | 19 | |||
| 77562 | 226327 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007824.63975 | 2105811.28938 | 37.7625986546389 | -122.416080374504 | (37.7625986546389, -122.416080374504) | 8 | 4 | 7 | 28859 | 19 | |||
| 82268 | 229743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | 8 | 4 | 5 | 28859 | 19 | |||
| 84269 | 228528 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | 8 | 4 | 7 | 28859 | 19 | |||
| 85893 | 229808 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1801 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009536.40285 | 2106125.11646 | 37.7635564478901 | -122.410182137596 | (37.7635564478901, -122.410182137596) | 8 | 4 | 8 | 28859 | 19 | |||
| 86346 | 30658 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.41772 | 2109608.9608 | 37.7730122661246 | -122.417204548653 | (37.7730122661246, -122.417204548653) | 8 | 2 | 9 | 28853 | 19 |
| 89952 | 190749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 111 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008907.60615 | 2111116.85343 | 37.7772273283225 | -122.412709866562 | (37.7772273283225, -122.412709866562) | 8 | 2 | 9 | 28853 | 34 | |||
| 90509 | 52078 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 266 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 3x3 | Permit Number 50281 | 6006938.43131737 | 2107937.41791562 | 37.7683866372255 | -122.419296287373 | (37.7683866372255, -122.419296287373) | 8 | 4 | 7 | 28853 | 19 | ||
| 95611 | 46553 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | ||
| 97397 | 36056 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
| 98448 | 190738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010533.72626 | 2107613.44503 | 37.7676989114041 | -122.406837595798 | (37.7676989114041, -122.406837595798) | 8 | 4 | 8 | 28853 | 19 | |||
| 99494 | 110374 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
| 99838 | 228533 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | 8 | 4 | 7 | 28853 | 19 | |||
| 102667 | 190730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.7681196762964 | -122.406876984296 | (37.7681196762964, -122.406876984296) | 8 | 4 | 8 | 28853 | 19 | |||
| 105723 | 110372 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 | |||
| 106771 | 228529 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | 8 | 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) );