trees
1,194 rows where qSpecies_id = 50 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66845 | 121803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 21 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 89871 | 12227 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.7359132010346 | -122.387848277235 | (37.7359132010346, -122.387848277235) | 10 | 3 | 8 | 58 | 1 | ||
| 41324 | 122711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012928.83224 | 2105933.48701 | 37.7632198451537 | -122.398435273093 | (37.7632198451537, -122.398435273093) | 14 | 3 | 8 | 28856 | 29 | |||
| 77662 | 123149 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 530 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992851.14917 | 2111838.68412 | 37.7782950080613 | -122.468306331193 | (37.7782950080613, -122.468306331193) | 11 | 6 | 2 | 54 | 11 | |||
| 101745 | 129099 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002192.18689 | 2118975.47765 | 37.7984258993922 | -122.436503225465 | (37.7984258993922, -122.436503225465) | 13 | 9 | 1 | 57 | 17 | |||
| 50870 | 129100 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 3 | : | Tree | Private 2 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.428036263087 | (37.7764530246232, -122.428036263087) | 7 | 9 | 11 | 28852 | 10 | |||
| 74222 | 129101 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 4 | : | Tree | Private 2 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | 7 | 9 | 11 | 28852 | 10 | |||
| 158091 | 129102 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 5 | : | Tree | Private 2 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | 7 | 9 | 11 | 28852 | 10 | |||
| 170851 | 129103 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1306x Montgomery St | 29 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.404594484269 | (37.8018982087863, -122.404594484269) | 3 | 1 | 10 | 308 | 23 | |||
| 142068 | 138814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 456 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005154.2758 | 2111127.9762 | 37.777046493419 | -122.425694638339 | (37.777046493419, -122.425694638339) | 7 | 9 | 11 | 28852 | 10 | |||
| 134576 | 138815 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 456 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005166.9007 | 2111130.9467 | 37.7770553630765 | -122.425651176317 | (37.7770553630765, -122.425651176317) | 7 | 9 | 11 | 28852 | 10 | |||
| 62699 | 138952 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004470.5657 | 2110964.0931 | 37.7765578523866 | -122.428048123596 | (37.7765578523866, -122.428048123596) | 7 | 9 | 11 | 28852 | 10 | |||
| 36754 | 138953 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 717 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004472.5713 | 2110950.3879 | 37.7765203347407 | -122.42804020876 | (37.7765203347407, -122.42804020876) | 7 | 9 | 11 | 28852 | 10 | |||
| 72626 | 138954 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 719 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004474.577 | 2110934.0085 | 37.7764754744029 | -122.428032102975 | (37.7764754744029, -122.428032102975) | 7 | 9 | 11 | 28852 | 10 | |||
| 158632 | 142077 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 36 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998850.2457 | 2110939.7307 | 37.7761713796539 | -122.447488599832 | (37.7761713796539, -122.447488599832) | 15 | 6 | 2 | 29492 | 16 | |||
| 161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
| 15985 | 149873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.31236 | 2102734.10944 | 37.7545824999013 | -122.389034293714 | (37.7545824999013, -122.389034293714) | 10 | 3 | 8 | 28856 | 29 | |||
| 18269 | 149874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.50669 | 2102715.11316 | 37.7545303509079 | -122.389032295422 | (37.7545303509079, -122.389032295422) | 10 | 3 | 8 | 28856 | 29 | |||
| 9391 | 149875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015583.80084 | 2102690.13073 | 37.7544618261772 | -122.38902607571 | (37.7544618261772, -122.38902607571) | 10 | 3 | 8 | 28856 | 29 | |||
| 16486 | 150546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012204.80057 | 2103865.42291 | 37.7575010382506 | -122.400794174114 | (37.7575010382506, -122.400794174114) | 10 | 3 | 8 | 28856 | 29 | |||
| 685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
| 129591 | 152667 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008576.51497 | 2103684.24515 | 37.7568005230537 | -122.413329473377 | (37.7568005230537, -122.413329473377) | 2 | 4 | 7 | 28859 | 19 | |
| 13037 | 152668 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008574.99769 | 2103713.14234 | 37.7568797829862 | -122.413336764205 | (37.7568797829862, -122.413336764205) | 2 | 4 | 7 | 28859 | 19 | |
| 4829 | 158177 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6003950.61422 | 2096725.29328 | 37.7374320507564 | -122.42883145083 | (37.7374320507564, -122.42883145083) | 2 | 7 | 5 | 63 | 7 | |||
| 1823 | 162258 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011414.80687 | 2091110.91102 | 37.7224357728692 | -122.402629394533 | (37.7224357728692, -122.402629394533) | 10 | 3 | 7 | 309 | 28 | ||
| 13592 | 162301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 238 Olmstead St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 0ft | 6010941.2062 | 2091035.49966 | 37.7222022558199 | -122.404261226995 | (37.7222022558199, -122.404261226995) | 10 | 3 | 7 | 309 | 28 | ||
| 18756 | 166228 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3180 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007809.26595 | 2102700.74025 | 37.7540569360932 | -122.41591326789 | (37.7540569360932, -122.41591326789) | 2 | 4 | 7 | 28859 | 19 | |||
| 938 | 167297 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3500 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004922.20627 | 2103712.53255 | 37.7566723462619 | -122.425969442941 | (37.7566723462619, -122.425969442941) | 2 | 4 | 5 | 28862 | 3 | |||
| 78698 | 173775 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1057 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779347 | 6009462.91602 | 2103024.17334 | 37.7550378411013 | -122.410217357343 | (37.7550378411013, -122.410217357343) | 2 | 4 | 7 | 28859 | 19 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 111834 | 176587 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 125 Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781437 | 6011540.71743 | 2090213.76704 | 37.7199794275941 | -122.402131106273 | (37.7199794275941, -122.402131106273) | 10 | 7 | 8 | 309 | 28 | |
| 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 | |||
| 60065 | 17889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | 13 | 9 | 11 | 29490 | 27 | ||
| 50377 | 18386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 816 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/1997 12:00:00 AM | 12 | 3X3 | 6010411.4798 | 2104364.47697 | 37.7587711399879 | -122.407031402383 | (37.7587711399879, -122.407031402383) | 10 | 4 | 7 | 28859 | 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 | |||
| 123168 | 190683 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Minnesota St | 39 | Front Yard : Yard | Tree | Private 2 | 4 | 6015372.42654 | 2102509.76476 | 37.7539548603504 | -122.389744472134 | (37.7539548603504, -122.389744472134) | 10 | 3 | 8 | 28856 | 29 | ||||
| 80801 | 190684 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014721.7183 | 2106200.75287 | 37.7640534132442 | -122.392252919633 | (37.7640534132442, -122.392252919633) | 14 | 3 | 8 | 28856 | 29 | |||
| 119323 | 190685 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014780.75112 | 2106205.10487 | 37.7640686405785 | -122.392049045151 | (37.7640686405785, -122.392049045151) | 14 | 3 | 8 | 28856 | 29 | |||
| 143485 | 190686 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014799.41703 | 2106205.91343 | 37.7640718970256 | -122.391984541257 | (37.7640718970256, -122.391984541257) | 14 | 3 | 8 | 28856 | 29 | |||
| 129660 | 190687 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | 10 | 3 | 8 | 28856 | 29 | |||
| 72353 | 190688 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015295.35609 | 2103854.98706 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | 10 | 3 | 8 | 28856 | 29 | |||
| 34108 | 190689 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.7575838496448 | -122.390100279027 | (37.7575838496448, -122.390100279027) | 10 | 3 | 8 | 28856 | 29 | |||
| 102465 | 190690 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.7575419601034 | -122.390097725855 | (37.7575419601034, -122.390097725855) | 10 | 3 | 8 | 28856 | 29 | |||
| 146544 | 190691 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015298.33049 | 2103800.67785 | 37.757495323968 | -122.390090891879 | (37.757495323968, -122.390090891879) | 10 | 3 | 8 | 28856 | 29 | |||
| 47404 | 190692 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6015546.55953 | 2104430.75491 | 37.7592391453969 | -122.389276405591 | (37.7592391453969, -122.389276405591) | 10 | 3 | 8 | 28856 | 29 | |||
| 49110 | 190693 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015286.01268 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | 10 | 3 | 8 | 28856 | 29 | |||
| 171733 | 190694 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013445.19565 | 2106684.95045 | 37.7653119497171 | -122.396702014197 | (37.7653119497171, -122.396702014197) | 14 | 3 | 8 | 28856 | 20 | |||
| 153794 | 190695 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013444.76571 | 2106699.32295 | 37.7653513894931 | -122.396704508917 | (37.7653513894931, -122.396704508917) | 14 | 3 | 8 | 28856 | 20 | |||
| 69954 | 190696 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013444.35032 | 2106714.41309 | 37.7653928005592 | -122.396707003628 | (37.7653928005592, -122.396707003628) | 14 | 3 | 8 | 28856 | 20 | |||
| 113872 | 190697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013439.7362 | 2106789.19698 | 37.7655978837597 | -122.396728206045 | (37.7655978837597, -122.396728206045) | 14 | 3 | 8 | 28856 | 20 | |||
| 130744 | 190698 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013440.07088 | 2106805.70814 | 37.7656432383768 | -122.396728206061 | (37.7656432383768, -122.396728206061) | 14 | 3 | 8 | 28856 | 20 | |||
| 28919 | 190699 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013438.17718 | 2106819.03274 | 37.7656797193792 | -122.3967356902 | (37.7656797193792, -122.3967356902) | 14 | 3 | 8 | 28856 | 20 | |||
| 124187 | 190700 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013754.83495 | 2106240.90179 | 37.7641099185662 | -122.395599922892 | (37.7641099185662, -122.395599922892) | 14 | 3 | 8 | 28856 | 29 | |||
| 2360 | 190701 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013753.34046 | 2106269.97699 | 37.7641896695377 | -122.395607129171 | (37.7641896695377, -122.395607129171) | 14 | 3 | 8 | 28856 | 29 | |||
| 78094 | 190702 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 648 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012372.02643 | 2104905.99747 | 37.7603675526457 | -122.400288920619 | (37.7603675526457, -122.400288920619) | 10 | 3 | 8 | 28856 | 29 | |||
| 2344 | 190703 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078787 | -122.400028798005 | (37.759589078787, -122.400028798005) | 10 | 3 | 8 | 28856 | 29 | |||
| 90656 | 190704 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6011711.12531 | 2101607.11223 | 37.7512726647182 | -122.402342728461 | (37.7512726647182, -122.402342728461) | 10 | 3 | 8 | 28856 | 29 | |||
| 80273 | 190705 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2207 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012167.67259 | 2101868.22715 | 37.7520151045386 | -122.400782269783 | (37.7520151045386, -122.400782269783) | 10 | 3 | 8 | 28856 | 29 | |||
| 61215 | 190706 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2221 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011852.8073 | 2101343.3115 | 37.7505562332917 | -122.401834231975 | (37.7505562332917, -122.401834231975) | 10 | 3 | 8 | 28856 | 1 | |||
| 77587 | 190707 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2221 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011869.78299 | 2101342.9203 | 37.7505561064965 | -122.401775500866 | (37.7505561064965, -122.401775500866) | 10 | 3 | 8 | 28856 | 1 | |||
| 29512 | 190708 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2033 22nd St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6011986.6004 | 2103715.0173 | 37.7570758846471 | -122.401538231824 | (37.7570758846471, -122.401538231824) | 10 | 3 | 8 | 28856 | 29 | |||
| 4292 | 190709 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | 10 | 3 | 8 | 28856 | 29 | |||
| 168986 | 190710 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012743.45877 | 2104190.05175 | 37.7584224278606 | -122.398954049707 | (37.7584224278606, -122.398954049707) | 10 | 3 | 8 | 28856 | 29 | |||
| 189822 | 190711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 285 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6013779.84023 | 2105755.3163 | 37.7627779983326 | -122.395479414663 | (37.7627779983326, -122.395479414663) | 14 | 3 | 8 | 28856 | 29 | |||
| 64645 | 190712 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Texas St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013703.78505 | 2106091.36578 | 37.7636964858312 | -122.395766012395 | (37.7636964858312, -122.395766012395) | 14 | 3 | 8 | 28856 | 29 | |||
| 179328 | 190713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6013844.95879 | 2104593.96331 | 37.7595927983841 | -122.395172837551 | (37.7595927983841, -122.395172837551) | 10 | 3 | 8 | 28856 | 29 | |||
| 159008 | 190714 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Texas St | 2 | : | Tree | Private 2 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.7617293870175 | -122.395381240171 | (37.7617293870175, -122.395381240171) | 10 | 3 | 8 | 28856 | 29 | |||
| 108357 | 190715 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 350 Texas St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6013737.51284 | 2105460.97147 | 37.7619674375704 | -122.395605187539 | (37.7619674375704, -122.395605187539) | 10 | 3 | 8 | 28856 | 29 | |||
| 101836 | 190716 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 333 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6012961.26572 | 2105490.25457 | 37.7620046335244 | -122.398291995789 | (37.7620046335244, -122.398291995789) | 10 | 3 | 8 | 28856 | 29 | |||
| 65837 | 190717 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1150 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.394222475384 | (37.7614940829991, -122.394222475384) | 10 | 3 | 8 | 28856 | 29 | |||
| 74250 | 190718 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 446 Missouri St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013483.0407 | 2105010.44498 | 37.7607162323997 | -122.396453732953 | (37.7607162323997, -122.396453732953) | 10 | 3 | 8 | 28856 | 29 | |||
| 45918 | 190719 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6014091.45327 | 2104130.33792 | 37.7583334885189 | -122.39428786959 | (37.7583334885189, -122.39428786959) | 10 | 3 | 8 | 28856 | 29 | |||
| 89588 | 190720 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 315 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014070.97859 | 2105596.22306 | 37.7623573521408 | -122.394461321843 | (37.7623573521408, -122.394461321843) | 10 | 3 | 8 | 28856 | 29 | |||
| 127440 | 190721 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2200 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010462.79733 | 2107890.40635 | 37.7684554148125 | -122.407102456039 | (37.7684554148125, -122.407102456039) | 8 | 4 | 8 | 28853 | 19 | |||
| 191355 | 190722 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2200 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010363.60354 | 2107883.96222 | 37.7684321691431 | -122.407445105823 | (37.7684321691431, -122.407445105823) | 8 | 4 | 8 | 28853 | 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 | |||
| 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 | |||
| 117455 | 190725 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010439.75315 | 2107847.13146 | 37.7683353022519 | -122.407179113336 | (37.7683353022519, -122.407179113336) | 8 | 4 | 8 | 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 | |||
| 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 | |||
| 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 | |||
| 175279 | 190729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010522.64899 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | 8 | 4 | 8 | 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 | |||
| 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 | |||
| 151047 | 190732 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.7679851656226 | -122.406867209579 | (37.7679851656226, -122.406867209579) | 8 | 4 | 8 | 28853 | 19 | |||
| 149430 | 190733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010530.15081 | 2107694.73579 | 37.767921917195 | -122.406855692832 | (37.767921917195, -122.406855692832) | 8 | 4 | 8 | 28853 | 19 | |||
| 156163 | 190734 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010530.37912 | 2107677.75559 | 37.7678753062214 | -122.406853706245 | (37.7678753062214, -122.406853706245) | 8 | 4 | 8 | 28853 | 19 | |||
| 160502 | 190735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010531.76595 | 2107657.21316 | 37.7678189790021 | -122.406847461368 | (37.7678189790021, -122.406847461368) | 8 | 4 | 8 | 28853 | 19 | |||
| 135288 | 190736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010534.2694 | 2107640.09784 | 37.7677721243224 | -122.406837595791 | (37.7677721243224, -122.406837595791) | 8 | 4 | 8 | 28853 | 19 | |||
| 121316 | 190737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010533.36081 | 2107625.71159 | 37.7677325721273 | -122.406839724475 | (37.7677325721273, -122.406839724475) | 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 | |||
| 180841 | 190739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010536.50922 | 2107598.98356 | 37.7676593592282 | -122.406826950508 | (37.7676593592282, -122.406826950508) | 8 | 4 | 8 | 28853 | 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 | |||
| 169649 | 190741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1786 Quesada Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014282.60323 | 2095390.34812 | 37.7343459381091 | -122.393015276746 | (37.7343459381091, -122.393015276746) | 10 | 3 | 8 | 58 | 1 | |||
| 176891 | 190742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1617 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6015073.9615 | 2096817.26033 | 37.7383078753038 | -122.390378936647 | (37.7383078753038, -122.390378936647) | 10 | 3 | 8 | 58 | 1 | |||
| 12291 | 190743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Latona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.7317380471513 | -122.392476830144 | (37.7317380471513, -122.392476830144) | 10 | 3 | 8 | 58 | 1 | |||
| 53657 | 190744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2086 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6012709.58294 | 2096557.7365 | 37.7374638381805 | -122.398535643704 | (37.7374638381805, -122.398535643704) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );