trees
619 rows where Fire Prevention Districts = 2 and 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157820 | 226386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | 2 | 7 | 7 | 28859 | 2 | |||
149748 | 226387 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | 2 | 7 | 7 | 28859 | 2 | |||
29233 | 226388 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006749.9144 | 2099207.72209 | 37.7444062878286 | -122.41932899196 | (37.7444062878286, -122.41932899196) | 2 | 7 | 7 | 28859 | 2 | |||
102856 | 226389 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | 2 | 7 | 7 | 28859 | 2 | |||
29462 | 226390 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006633.7821 | 2097989.5025 | 37.7410547888452 | -122.419644136891 | (37.7410547888452, -122.419644136891) | 2 | 7 | 7 | 28859 | 2 | |||
75930 | 226391 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.7460665100597 | -122.414972850429 | (37.7460665100597, -122.414972850429) | 2 | 7 | 7 | 28859 | 2 | |||
32766 | 226392 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.7460275775108 | -122.414955412565 | (37.7460275775108, -122.414955412565) | 2 | 7 | 7 | 28859 | 2 | |||
69053 | 226393 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.7459034791769 | -122.414943103567 | (37.7459034791769, -122.414943103567) | 2 | 7 | 7 | 28859 | 2 | |||
44395 | 226394 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008031.02829 | 2099712.86133 | 37.7458653577975 | -122.414934898137 | (37.7458653577975, -122.414934898137) | 2 | 7 | 7 | 28859 | 2 | |||
51307 | 226395 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008034.1838 | 2099620.63234 | 37.7456122948636 | -122.414917460292 | (37.7456122948636, -122.414917460292) | 2 | 7 | 7 | 28859 | 2 | |||
58760 | 226396 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1483 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008038.28994 | 2099516.86307 | 37.7453275982942 | -122.41489591881 | (37.7453275982942, -122.41489591881) | 2 | 7 | 7 | 28859 | 2 | |||
129802 | 226397 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1490 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008007.72496 | 2099487.35787 | 37.745244866072 | -122.414999519809 | (37.745244866072, -122.414999519809) | 2 | 7 | 7 | 28859 | 2 | |||
131818 | 226398 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008004.95256 | 2099511.34192 | 37.7453105651388 | -122.415010803607 | (37.7453105651388, -122.415010803607) | 2 | 7 | 7 | 28859 | 2 | |||
108736 | 226399 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.7453608534324 | -122.41501490632 | (37.7453608534324, -122.41501490632) | 2 | 7 | 7 | 28859 | 2 | |||
130148 | 226400 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1480 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008001.07248 | 2099553.66374 | 37.7454265533887 | -122.415027215335 | (37.7454265533887, -122.415027215335) | 2 | 7 | 7 | 28859 | 2 | |||
83706 | 226401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008220.52934 | 2099483.50303 | 37.7452462375173 | -122.414263403134 | (37.7452462375173, -122.414263403134) | 2 | 7 | 7 | 28859 | 2 | |||
6734 | 226402 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008216.93199 | 2099535.32688 | 37.7453883322157 | -122.414279508218 | (37.7453883322157, -122.414279508218) | 2 | 7 | 7 | 28859 | 2 | |||
100983 | 226403 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008209.69188 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | 2 | 7 | 7 | 28859 | 2 | |||
97822 | 226404 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.7465441607 | -122.416469871814 | (37.7465441607, -122.416469871814) | 2 | 7 | 7 | 28859 | 2 | |||
179723 | 226405 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628925 | -122.415012541103 | (37.746498628925, -122.415012541103) | 2 | 7 | 7 | 28859 | 2 | |||
166585 | 226406 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008014.49827 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | 2 | 7 | 7 | 28859 | 2 | |||
7478 | 226407 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006002.53632 | 2097682.69863 | 37.7401767960293 | -122.421804971219 | (37.7401767960293, -122.421804971219) | 2 | 7 | 7 | 28859 | 2 | |||
106394 | 226408 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 324 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006517.91503 | 2097301.91264 | 37.739160293208 | -122.419995981327 | (37.739160293208, -122.419995981327) | 2 | 7 | 7 | 28859 | 2 | |||
20282 | 226409 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007041.57099 | 2096614.16719 | 37.7373013855609 | -122.418136666301 | (37.7373013855609, -122.418136666301) | 2 | 7 | 7 | 28859 | 2 | |||
110808 | 226410 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007045.3382 | 2096649.72314 | 37.7373992263821 | -122.418126161295 | (37.7373992263821, -122.418126161295) | 2 | 7 | 7 | 28859 | 2 | |||
181833 | 226412 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1987 12:00:00 AM | 14 | Width 3ft | Permit Number 24387 | 6008267.80034 | 2100190.98708 | 37.7471914863912 | -122.41414999144 | (37.7471914863912, -122.41414999144) | 2 | 7 | 7 | 28859 | 2 | |
77571 | 226413 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009277.36888 | 2100886.87778 | 37.7491589026595 | -122.41070810519 | (37.7491589026595, -122.41070810519) | 2 | 4 | 7 | 28859 | 19 | |||
59072 | 226414 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1174 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009199.3273 | 2102350.17557 | 37.7531724159966 | -122.411081321155 | (37.7531724159966, -122.411081321155) | 2 | 4 | 7 | 28859 | 19 | |||
83277 | 226415 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009167.57752 | 2102926.63896 | 37.754753474499 | -122.411231837073 | (37.754753474499, -122.411231837073) | 2 | 4 | 7 | 28859 | 19 | |||
94876 | 226416 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1118 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008031.51023 | 2101373.79083 | 37.7504259251155 | -122.415050773974 | (37.7504259251155, -122.415050773974) | 2 | 4 | 7 | 28859 | 19 | |||
56974 | 226417 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008029.19909 | 2101392.11657 | 37.7504761135956 | -122.415060063068 | (37.7504761135956, -122.415060063068) | 2 | 4 | 7 | 28859 | 19 | |||
145243 | 226418 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008030.04777 | 2101411.71526 | 37.7505299748764 | -122.415058515332 | (37.7505299748764, -122.415058515332) | 2 | 4 | 7 | 28859 | 19 | |||
112398 | 226419 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 932 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007979.64844 | 2102295.8954 | 37.7529549014529 | -122.415295385088 | (37.7529549014529, -122.415295385088) | 2 | 4 | 7 | 28859 | 19 | |||
128146 | 226420 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 632 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007871.67107 | 2104237.72294 | 37.7582806479376 | -122.415806280941 | (37.7582806479376, -122.415806280941) | 2 | 4 | 7 | 28859 | 19 | |||
162863 | 226421 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3354 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007857.16487 | 2104491.21664 | 37.7589758679475 | -122.415874400085 | (37.7589758679475, -122.415874400085) | 2 | 4 | 7 | 28859 | 19 | |||
186401 | 226422 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3354 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007858.2602 | 2104522.84344 | 37.7590627694542 | -122.415872851461 | (37.7590627694542, -122.415872851461) | 2 | 4 | 7 | 28859 | 19 | |||
44643 | 226423 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 582 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007852.94487 | 2104547.46953 | 37.7591300882142 | -122.415892978285 | (37.7591300882142, -122.415892978285) | 2 | 4 | 7 | 28859 | 19 | |||
178778 | 226424 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007852.84367 | 2104586.25311 | 37.7592365733232 | -122.415896074661 | (37.7592365733232, -122.415896074661) | 2 | 4 | 7 | 28859 | 19 | |||
140480 | 226425 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005988.79838 | 2101974.74893 | 37.7519610156893 | -122.422157319311 | (37.7519610156893, -122.422157319311) | 2 | 4 | 5 | 28859 | 19 | |||
156039 | 226426 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3323 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006880.3188 | 2102604.06002 | 37.7537392047139 | -122.419118940914 | (37.7537392047139, -122.419118940914) | 2 | 4 | 7 | 28859 | 19 | |||
128732 | 226427 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006674.0476 | 2102914.93571 | 37.7545811796958 | -122.419854332733 | (37.7545811796958, -122.419854332733) | 2 | 4 | 7 | 28859 | 19 | |||
192973 | 226428 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006671.33563 | 2102940.18758 | 37.7546503627401 | -122.419865503217 | (37.7546503627401, -122.419865503217) | 2 | 4 | 7 | 28859 | 19 | |||
44484 | 226429 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006669.22772 | 2102968.64373 | 37.7547283780289 | -122.419874812075 | (37.7547283780289, -122.419874812075) | 2 | 4 | 7 | 28859 | 19 | |||
53093 | 226430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.7547990323663 | -122.419878535269 | (37.7547990323663, -122.419878535269) | 2 | 4 | 7 | 28859 | 19 | |||
69822 | 226431 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006664.92393 | 2103021.2685 | 37.7548726310745 | -122.419893429847 | (37.7548726310745, -122.419893429847) | 2 | 4 | 7 | 28859 | 19 | |||
68745 | 226432 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006660.51047 | 2103068.53452 | 37.7550021640414 | -122.41991204672 | (37.7550021640414, -122.41991204672) | 2 | 4 | 7 | 28859 | 19 | |||
28301 | 226433 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006663.83853 | 2103099.55931 | 37.7550875384663 | -122.419902738742 | (37.7550875384663, -122.419902738742) | 2 | 4 | 7 | 28859 | 19 | |||
79294 | 226434 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006662.06006 | 2103117.82252 | 37.7551375848404 | -122.419910185127 | (37.7551375848404, -122.419910185127) | 2 | 4 | 7 | 28859 | 19 | |||
191365 | 226435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006660.81941 | 2103136.07502 | 37.7551876321062 | -122.419915770819 | (37.7551876321062, -122.419915770819) | 2 | 4 | 7 | 28859 | 19 | |||
109114 | 226436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006661.69832 | 2103152.67554 | 37.7552332628263 | -122.419913909217 | (37.7552332628263, -122.419913909217) | 2 | 4 | 7 | 28859 | 19 | |||
29253 | 226437 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006735.95617 | 2102521.24604 | 37.7535036857516 | -122.419612305359 | (37.7535036857516, -122.419612305359) | 2 | 4 | 7 | 28859 | 19 | |||
11201 | 226438 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006736.74676 | 2102507.29113 | 37.7534654133023 | -122.419608581296 | (37.7534654133023, -122.419608581296) | 2 | 4 | 7 | 28859 | 19 | |||
103022 | 226439 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 355 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006776.41109 | 2101737.70398 | 37.751354537191 | -122.419416820631 | (37.751354537191, -122.419416820631) | 2 | 4 | 7 | 28859 | 19 | |||
30369 | 226440 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 501 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006828.67283 | 2100820.93756 | 37.7488402485934 | -122.419171070095 | (37.7488402485934, -122.419171070095) | 2 | 4 | 7 | 28859 | 19 | |||
168892 | 226441 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 507 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006831.87915 | 2100767.2588 | 37.7486930394633 | -122.419156175534 | (37.7486930394633, -122.419156175534) | 2 | 4 | 7 | 28859 | 19 | |||
125687 | 226442 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008090.25065 | 2101545.29399 | 37.7509001349316 | -122.414859781372 | (37.7509001349316, -122.414859781372) | 2 | 4 | 7 | 28859 | 19 | |||
41706 | 226443 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3190 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008436.7771 | 2101566.08648 | 37.7509766915292 | -122.413662926703 | (37.7509766915292, -122.413662926703) | 2 | 4 | 7 | 28859 | 19 | |||
42682 | 226444 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3184 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008475.72782 | 2101569.16263 | 37.750987325127 | -122.413528448383 | (37.750987325127, -122.413528448383) | 2 | 4 | 7 | 28859 | 19 | |||
40544 | 226445 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3176 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008495.22679 | 2101571.86166 | 37.7509958309158 | -122.41346120966 | (37.7509958309158, -122.41346120966) | 2 | 4 | 7 | 28859 | 19 | |||
80265 | 226446 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3102 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008932.04499 | 2101596.23583 | 37.7510872739702 | -122.411952365814 | (37.7510872739702, -122.411952365814) | 2 | 4 | 7 | 28859 | 19 | |||
133133 | 226447 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3170 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007854.47288 | 2102702.51383 | 37.7540643473922 | -122.415757056543 | (37.7540643473922, -122.415757056543) | 2 | 4 | 7 | 28859 | 19 | |||
27538 | 226448 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008539 | 2102800 | 37.7543704799177 | -122.41339668212 | (37.7543704799177, -122.41339668212) | 2 | 4 | 7 | 28859 | 19 | |||
138806 | 226450 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008539 | 2102800 | 37.7543704799177 | -122.41339668212 | (37.7543704799177, -122.41339668212) | 2 | 4 | 7 | 28859 | 19 | |||
164441 | 226451 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008441.9337 | 2102736.37343 | 37.7541903253234 | -122.413727863145 | (37.7541903253234, -122.413727863145) | 2 | 4 | 7 | 28859 | 19 | |||
93521 | 226452 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008472.25902 | 2102739.35181 | 37.7542002061943 | -122.413623200976 | (37.7542002061943, -122.413623200976) | 2 | 4 | 7 | 28859 | 19 | |||
181741 | 226453 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008553.18177 | 2102742.64498 | 37.754213792241 | -122.41334358196 | (37.754213792241, -122.41334358196) | 2 | 4 | 7 | 28859 | 19 | |||
24898 | 226454 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3273 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006579.31902 | 2103170.31631 | 37.7552770588978 | -122.420200053701 | (37.7552770588978, -122.420200053701) | 2 | 4 | 7 | 28859 | 19 | |||
75305 | 226455 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008017.57842 | 2104465.14642 | 37.7589133021322 | -122.4153177674 | (37.7589133021322, -122.4153177674) | 2 | 4 | 7 | 28859 | 19 | |||
141843 | 226456 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008043.14081 | 2104467.44618 | 37.7589210533947 | -122.41522952324 | (37.7589210533947, -122.41522952324) | 2 | 4 | 7 | 28859 | 19 | |||
111480 | 226457 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008057.36787 | 2104469.97829 | 37.758928805544 | -122.415180498503 | (37.758928805544, -122.415180498503) | 2 | 4 | 7 | 28859 | 19 | |||
45979 | 226458 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3318 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008112.40239 | 2104471.67491 | 37.7589365568012 | -122.41499028288 | (37.7589365568012, -122.41499028288) | 2 | 4 | 7 | 28859 | 19 | |||
84662 | 226463 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2680 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008883.38252 | 2102935.43228 | 37.7547616763342 | -122.412215286208 | (37.7547616763342, -122.412215286208) | 2 | 4 | 7 | 28859 | 19 | |||
12973 | 226464 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2670 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008878.67119 | 2102975.76915 | 37.7548721679187 | -122.412234430081 | (37.7548721679187, -122.412234430081) | 2 | 4 | 7 | 28859 | 19 | |||
79921 | 226465 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2664 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008878.80492 | 2103009.39191 | 37.7549644959368 | -122.412236343845 | (37.7549644959368, -122.412236343845) | 2 | 4 | 7 | 28859 | 19 | |||
165178 | 226466 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 28th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.422516309799 | (37.7455065507954, -122.422516309799) | 2 | 7 | 5 | 28859 | 22 | |||
151810 | 226467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 11 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726947 | (37.7455007798334, -122.42261726947) | 2 | 7 | 5 | 28859 | 22 | |||
140189 | 226761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005532.06027 | 2099607.16908 | 37.7454344125679 | -122.423568476998 | (37.7454344125679, -122.423568476998) | 2 | 7 | 5 | 28859 | 22 | |||
153280 | 226762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005544.98011 | 2099653.84342 | 37.7455632989187 | -122.423527119901 | (37.7455632989187, -122.423527119901) | 2 | 7 | 5 | 28859 | 22 | |||
167928 | 226763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.423709577049 | (37.7463491139326, -122.423709577049) | 2 | 7 | 5 | 28859 | 22 | |||
18693 | 226764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004212.35359 | 2095476.21584 | 37.7340171774496 | -122.427837519201 | (37.7340171774496, -122.427837519201) | 2 | 7 | 5 | 28861 | 25 | |||
157299 | 226765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | 2 | 7 | 5 | 28861 | 25 | |||
121342 | 226766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005428.90079 | 2099643.28917 | 37.7455277666988 | -122.423927754381 | (37.7455277666988, -122.423927754381) | 2 | 7 | 5 | 28859 | 22 | |||
52017 | 226767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001499.39319 | 2102307.79719 | 37.752621244884 | -122.437706147824 | (37.752621244884, -122.437706147824) | 2 | 4 | 5 | 28862 | 22 | |||
39925 | 226768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001810.12784 | 2102797.39865 | 37.7539832366425 | -122.436666617866 | (37.7539832366425, -122.436666617866) | 2 | 4 | 5 | 28862 | 22 | |||
91105 | 226769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001809.15664 | 2102809.6039 | 37.7540166941382 | -122.4366708501 | (37.7540166941382, -122.4366708501) | 2 | 4 | 5 | 28862 | 22 | |||
90350 | 226770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001804.17577 | 2102825.14189 | 37.7540590746692 | -122.436689187264 | (37.7540590746692, -122.436689187264) | 2 | 4 | 5 | 28862 | 22 | |||
31344 | 226771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 822 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003061.62277 | 2103431.29043 | 37.7557947949988 | -122.432383924871 | (37.7557947949988, -122.432383924871) | 2 | 4 | 5 | 28862 | 22 | |||
3767 | 226772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 580 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002600.09968 | 2103291.61408 | 37.7553850962495 | -122.433970034883 | (37.7553850962495, -122.433970034883) | 2 | 4 | 5 | 28862 | 22 | |||
188574 | 226773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.7530417058104 | -122.432759865801 | (37.7530417058104, -122.432759865801) | 2 | 4 | 5 | 28862 | 22 | |||
82529 | 226774 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4069 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003404.88062 | 2101242.91418 | 37.7498054882307 | -122.431040646222 | (37.7498054882307, -122.431040646222) | 2 | 4 | 5 | 28862 | 22 | |||
31239 | 226775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4065 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003443.87888 | 2101243.2515 | 37.7498086241662 | -122.430905812676 | (37.7498086241662, -122.430905812676) | 2 | 4 | 5 | 28862 | 22 | |||
149017 | 226776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 16 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6004065.40509 | 2102868.59003 | 37.7543066193819 | -122.428872407741 | (37.7543066193819, -122.428872407741) | 2 | 4 | 5 | 28862 | 22 | |||
185908 | 226777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 323 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004194.76383 | 2103338.46367 | 37.7556041027521 | -122.428458541531 | (37.7556041027521, -122.428458541531) | 2 | 4 | 5 | 28862 | 22 | |||
153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
155526 | 226784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003023.04842 | 2105091.71244 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | 2 | 4 | 5 | 28862 | 3 | |||
186551 | 226785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.7596405020293 | -122.429996893968 | (37.7596405020293, -122.429996893968) | 2 | 4 | 5 | 28862 | 3 | |||
184418 | 226786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003740.86919 | 2104813.89584 | 37.7596295932412 | -122.430133501864 | (37.7596295932412, -122.430133501864) | 2 | 4 | 5 | 28862 | 3 | |||
109397 | 226787 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 166 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002663.06838 | 2104932.43611 | 37.7598939732341 | -122.43386954555 | (37.7598939732341, -122.43386954555) | 2 | 4 | 5 | 28862 | 3 | |||
153755 | 226788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 133 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002056.46904 | 2105062.33058 | 37.7602161904576 | -122.43597676864 | (37.7602161904576, -122.43597676864) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );