trees
218 rows where qSpecies_id = 175 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192445 | 240927 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008036.38125 | 2101261.79072 | 37.7501186717498 | -122.415026003064 | (37.7501186717498, -122.415026003064) | 2 | 4 | 7 | 28859 | 19 | |||
191824 | 248014 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6009926.50706 | 2098096.52796 | 37.7415335869952 | -122.408266587028 | (37.7415335869952, -122.408266587028) | 10 | 7 | 7 | 28859 | 2 | |||
191689 | 197413 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014976.00474 | 2109834.88715 | 37.7740460629032 | -122.391627511322 | (37.7740460629032, -122.391627511322) | 14 | 3 | 9 | 310 | 20 | |||
191508 | 197415 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014984.86554 | 2109771.18409 | 37.7738716403058 | -122.391592405366 | (37.7738716403058, -122.391592405366) | 14 | 3 | 9 | 310 | 20 | |||
190311 | 197427 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015011.53303 | 2109302.8867 | 37.7725872798057 | -122.391467412186 | (37.7725872798057, -122.391467412186) | 14 | 3 | 9 | 310 | 20 | |||
189799 | 197395 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015072.84458 | 2109194.41705 | 37.7722928489542 | -122.391247743804 | (37.7722928489542, -122.391247743804) | 14 | 3 | 9 | 310 | 20 | |||
189230 | 240940 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 671 Church St | 52 | Front Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 6004314.46376 | 2105211.05218 | 37.7607525605073 | -122.428178028592 | (37.7607525605073, -122.428178028592) | 2 | 4 | 5 | 28862 | 3 | |||
188504 | 197419 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014990.75817 | 2109661.05319 | 37.7735695724098 | -122.391564320444 | (37.7735695724098, -122.391564320444) | 14 | 3 | 9 | 310 | 20 | |||
187607 | 34468 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1725 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 6 | Permit Number 41458 | 6008697.37022 | 2118963.2326 | 37.7987597807915 | -122.413992350181 | (37.7987597807915, -122.413992350181) | 5 | 1 | 10 | 308 | 21 | |
186115 | 240510 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 180 Guerrero St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005414.72148 | 2107962.30986 | 37.7683690520207 | -122.424568435908 | (37.7683690520207, -122.424568435908) | 8 | 4 | 5 | 28853 | 19 | |||
185459 | 240921 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 301 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001181.68085 | 2096585.46393 | 37.7368910024193 | -122.438394913397 | (37.7368910024193, -122.438394913397) | 2 | 7 | 5 | 63 | 7 | |||
184785 | 240922 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 25 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001848.30609 | 2096993.36955 | 37.7380489119203 | -122.436119279702 | (37.7380489119203, -122.436119279702) | 2 | 7 | 5 | 63 | 7 | |||
184737 | 240517 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 3012 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009425.7418 | 2101039.02648 | 37.7495849870744 | -122.410205768204 | (37.7495849870744, -122.410205768204) | 2 | 4 | 7 | 28859 | 19 | |||
184499 | 240932 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 4586 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000693.49124 | 2104675.50422 | 37.7590765362773 | -122.44066290647 | (37.7590765362773, -122.44066290647) | 2 | 4 | 5 | 28862 | 3 | |||
183363 | 197430 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015016.26814 | 2109221.75475 | 37.7723647722597 | -122.39144535991 | (37.7723647722597, -122.39144535991) | 14 | 3 | 9 | 310 | 20 | |||
183111 | 240926 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009479.18585 | 2101981.64475 | 37.752176202776 | -122.410087494765 | (37.752176202776, -122.410087494765) | 2 | 4 | 7 | 28859 | 19 | |||
181174 | 136354 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1508 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005758.24578 | 2118617.72057 | 37.7976455819407 | -122.424138095904 | (37.7976455819407, -122.424138095904) | 13 | 9 | 1 | 57 | 17 | |||
181043 | 197382 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 500 Berry St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6012329.59735 | 2108461.51714 | 37.7701278489399 | -122.400685446092 | (37.7701278489399, -122.400685446092) | 14 | 2 | 8 | 28856 | 20 | |||
180039 | 197396 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015072.31734 | 2109224.65896 | 37.7723758572837 | -122.391251681939 | (37.7723758572837, -122.391251681939) | 14 | 3 | 9 | 310 | 20 | |||
179641 | 248018 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6009957.63664 | 2098204.23496 | 37.7418310701357 | -122.408166545559 | (37.7418310701357, -122.408166545559) | 10 | 7 | 7 | 28859 | 2 | |||
179638 | 240947 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 80 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002399.94637 | 2096660.61208 | 37.7371665618784 | -122.434188205941 | (37.7371665618784, -122.434188205941) | 2 | 7 | 5 | 63 | 7 | |||
179619 | 197380 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2251 Silver Ave | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012873.30802 | 2096314.08493 | 37.7368039417418 | -122.397952478343 | (37.7368039417418, -122.397952478343) | 10 | 3 | 8 | 58 | 1 | |||
179190 | 197384 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015096.00206 | 2108800.56286 | 37.7712126975445 | -122.391140104833 | (37.7712126975445, -122.391140104833) | 14 | 3 | 9 | 310 | 20 | |||
179099 | 197411 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015024.81769 | 2109879.03654 | 37.774169996686 | -122.391461744659 | (37.774169996686, -122.391461744659) | 14 | 3 | 9 | 310 | 20 | |||
178435 | 197437 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015033.58338 | 2108913.15742 | 37.771518393298 | -122.391363887653 | (37.771518393298, -122.391363887653) | 14 | 3 | 9 | 310 | 20 | |||
177511 | 240908 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 725 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009319.31515 | 2104845.25039 | 37.7600300568648 | -122.410842580843 | (37.7600300568648, -122.410842580843) | 2 | 4 | 7 | 28859 | 19 | |||
176330 | 136360 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1725 Taylor St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008711.32926 | 2118885.42513 | 37.7985469247543 | -122.413938540155 | (37.7985469247543, -122.413938540155) | 5 | 1 | 10 | 308 | 21 | |||
175533 | 96392 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767136 | 6015444.53946 | 2105235.26093 | 37.7614424898011 | -122.389685433429 | (37.7614424898011, -122.389685433429) | 10 | 3 | 8 | 28856 | 29 | |
175397 | 240929 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 147 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005793.48345 | 2096408.78374 | 37.7366671197906 | -122.422437298044 | (37.7366671197906, -122.422437298044) | 2 | 7 | 7 | 28859 | 2 | |||
174218 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
173830 | 98139 | Property Tree 8 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 556 Laidley St | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003085 | 2096041 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | 2 | 7 | 5 | 63 | 7 | |||||
173113 | 197439 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015038.53037 | 2108853.85657 | 37.7713558408268 | -122.39134262946 | (37.7713558408268, -122.39134262946) | 14 | 3 | 9 | 310 | 20 | |||
173099 | 197440 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015037.52027 | 2108824.47635 | 37.7712751131743 | -122.391344069293 | (37.7712751131743, -122.391344069293) | 14 | 3 | 9 | 310 | 20 | |||
171946 | 197420 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014998.57837 | 2109523.60508 | 37.7731926044861 | -122.391527657797 | (37.7731926044861, -122.391527657797) | 14 | 3 | 9 | 310 | 20 | |||
168030 | 38986 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 300x San Bruno Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40762 | 6010873.0726 | 2106579.57544 | 37.764879122199 | -122.405591006845 | (37.764879122199, -122.405591006845) | 8 | 4 | 8 | 28853 | 19 | |
167877 | 214144 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1349 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991798.36054 | 2098388.78808 | 37.7413042814624 | -122.470968230225 | (37.7413042814624, -122.470968230225) | 1 | 8 | 4 | 59 | 40 | |||
167371 | 197428 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015013.65902 | 2109278.19684 | 37.7725196049206 | -122.39145833173 | (37.7725196049206, -122.39145833173) | 14 | 3 | 9 | 310 | 20 | |||
164648 | 240511 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 301 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009219.87224 | 2106727.21512 | 37.7651919252958 | -122.411319458036 | (37.7651919252958, -122.411319458036) | 8 | 4 | 7 | 28859 | 19 | |||
161828 | 197446 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013697.34857 | 2108075.95156 | 37.7691453611896 | -122.395927352578 | (37.7691453611896, -122.395927352578) | 14 | 3 | 9 | 310 | 20 | |||
160139 | 214145 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 763 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5994412.31981 | 2089911.68569 | 37.7181790612911 | -122.46131577523 | (37.7181790612911, -122.46131577523) | 9 | 8 | 6 | 28861 | 24 | |||
159435 | 197379 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014025.29232 | 2102006.07579 | 37.7524970440096 | -122.394367951529 | (37.7524970440096, -122.394367951529) | 10 | 3 | 8 | 28856 | 29 | |||
159316 | 197423 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015003.80632 | 2109440.09446 | 37.7729635930298 | -122.391503734027 | (37.7729635930298, -122.391503734027) | 14 | 3 | 9 | 310 | 20 | |||
159262 | 240891 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008718.64971 | 2101088.20431 | 37.7496803583719 | -122.41265440089 | (37.7496803583719, -122.41265440089) | 2 | 4 | 7 | 28859 | 19 | |||
158338 | 258480 | Undocumented 4 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1721x Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008705 | 2118812 | 37.7983449620815 | -122.413955244514 | (37.7983449620815, -122.413955244514) | 5 | 1 | 10 | 308 | 21 | ||||
157744 | 197421 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015000.43242 | 2109495.8046 | 37.7731163734468 | -122.391519300385 | (37.7731163734468, -122.391519300385) | 14 | 3 | 9 | 310 | 20 | |||
157695 | 240898 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008707.03966 | 2101316.20021 | 37.7503057325231 | -122.412710665178 | (37.7503057325231, -122.412710665178) | 2 | 4 | 7 | 28859 | 19 | |||
155384 | 240907 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 355 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007123.31174 | 2096296.95431 | 37.7364349894799 | -122.417831571267 | (37.7364349894799, -122.417831571267) | 2 | 7 | 7 | 28859 | 2 | |||
154875 | 248251 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 104 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006828.21507 | 2098946.74431 | 37.7436941111088 | -122.419039736691 | (37.7436941111088, -122.419039736691) | 2 | 7 | 7 | 28859 | 2 | |||
154513 | 197451 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009234.52734 | 2111091.20385 | 37.7771752440663 | -122.41157712459 | (37.7771752440663, -122.41157712459) | 8 | 2 | 9 | 28853 | 34 | |||
154144 | 38496 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1520 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | 7 | Permit Number 40490 | 6005695.28325 | 2118608.46159 | 37.79761660398 | -122.424355304657 | (37.79761660398, -122.424355304657) | 13 | 9 | 1 | 57 | 17 | |
153109 | 197397 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015070.62155 | 2109253.41262 | 37.7724547143562 | -122.391259558193 | (37.7724547143562, -122.391259558193) | 14 | 3 | 9 | 310 | 20 | |||
151879 | 248011 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6009911.76805 | 2098028.06886 | 37.7413447878202 | -122.408312722264 | (37.7413447878202, -122.408312722264) | 10 | 7 | 7 | 28859 | 2 | |||
151741 | 240944 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 88 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004279.64168 | 2097645.58275 | 37.7399775737156 | -122.427759401399 | (37.7399775737156, -122.427759401399) | 2 | 7 | 5 | 63 | 7 | |||
150712 | 240894 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008712.70804 | 2101184.15131 | 37.7499434739162 | -122.412681729505 | (37.7499434739162, -122.412681729505) | 2 | 4 | 7 | 28859 | 19 | |||
150221 | 240917 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 83 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005893.634 | 2099040.45784 | 37.7438987545233 | -122.422277954379 | (37.7438987545233, -122.422277954379) | 2 | 7 | 7 | 28859 | 2 | |||
149465 | 197400 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015059.96176 | 2109443.99349 | 37.7729774155998 | -122.391309756557 | (37.7729774155998, -122.391309756557) | 14 | 3 | 9 | 310 | 20 | |||
149133 | 197435 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015029.61492 | 2108966.93535 | 37.7716658353527 | -122.391381374959 | (37.7716658353527, -122.391381374959) | 14 | 3 | 9 | 310 | 20 | |||
148718 | 197418 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014989.55587 | 2109687.64207 | 37.7736425128315 | -122.391570338707 | (37.7736425128315, -122.391570338707) | 14 | 3 | 9 | 310 | 20 | |||
148240 | 240912 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 85 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006337.23732 | 2105831.0184 | 37.7625690840066 | -122.421226172049 | (37.7625690840066, -122.421226172049) | 8 | 4 | 7 | 28859 | 19 | |||
145732 | 197386 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015093.74839 | 2108858.04846 | 37.7713704152436 | -122.391151919239 | (37.7713704152436, -122.391151919239) | 14 | 3 | 9 | 310 | 20 | |||
145117 | 136358 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1725 Taylor St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008706.64463 | 2118922.43677 | 37.7986482864407 | -122.413957370134 | (37.7986482864407, -122.413957370134) | 5 | 1 | 10 | 308 | 21 | |||
144750 | 240939 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 671 Church St | 51 | Front Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 6004310.3515 | 2105242.11152 | 37.7608376093901 | -122.428194464629 | (37.7608376093901, -122.428194464629) | 2 | 4 | 5 | 28862 | 3 | |||
143907 | 240887 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 3009 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6009470.6055 | 2100993.60175 | 37.7494627754843 | -122.410047420976 | (37.7494627754843, -122.410047420976) | 2 | 4 | 7 | 28859 | 19 | |||
143573 | 197383 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015097.30322 | 2108771.06093 | 37.7711317639632 | -122.391133541578 | (37.7711317639632, -122.391133541578) | 14 | 3 | 9 | 310 | 20 | |||
143500 | 197422 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015001.02116 | 2109469.2789 | 37.7730435724386 | -122.391515409031 | (37.7730435724386, -122.391515409031) | 14 | 3 | 9 | 310 | 20 | |||
142946 | 197390 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015085.78148 | 2108970.82178 | 37.7716796237449 | -122.39118736151 | (37.7716796237449, -122.39118736151) | 14 | 3 | 9 | 310 | 20 | |||
140843 | 136359 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1725 Taylor St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008708.52224 | 2118897.84426 | 37.7985808669576 | -122.413949132363 | (37.7985808669576, -122.413949132363) | 5 | 1 | 10 | 308 | 21 | |||
138292 | 197409 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015038.49943 | 2109813.6639 | 37.7739912573174 | -122.391409845709 | (37.7739912573174, -122.391409845709) | 14 | 3 | 9 | 310 | 20 | |||
136671 | 197408 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015042.21783 | 2109774.95767 | 37.773885184988 | -122.391394276636 | (37.773885184988, -122.391394276636) | 14 | 3 | 9 | 310 | 20 | |||
135480 | 197416 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014985.69638 | 2109740.56035 | 37.773787600441 | -122.391587389862 | (37.773787600441, -122.391587389862) | 14 | 3 | 9 | 310 | 20 | |||
134960 | 197456 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009124.38702 | 2110985.06111 | 37.7768776224341 | -122.411950633731 | (37.7768776224341, -122.411950633731) | 8 | 2 | 9 | 28853 | 34 | |||
134025 | 197449 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009262.53236 | 2111115.69015 | 37.7772440485182 | -122.411481976333 | (37.7772440485182, -122.411481976333) | 8 | 2 | 9 | 28853 | 34 | |||
132466 | 34777 | Permitted Site 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | 12 | 4xt | Permit Number 45651 | 6008035.00461404 | 2101235.83901924 | 37.7500473368591 | -122.415028926905 | (37.7500473368591, -122.415028926905) | 2 | 4 | 7 | 28859 | 19 |
131703 | 240914 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006391.17124 | 2105833.44907 | 37.7625787985022 | -122.421039806442 | (37.7625787985022, -122.421039806442) | 8 | 4 | 7 | 28859 | 19 | |||
131614 | 197448 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009272.74588 | 2111128.58634 | 37.7772800312881 | -122.411447555674 | (37.7772800312881, -122.411447555674) | 8 | 2 | 9 | 28853 | 34 | |||
130383 | 251714 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 6 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
126654 | 197393 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015077.38157 | 2109137.26391 | 37.7721361708673 | -122.391228054034 | (37.7721361708673, -122.391228054034) | 14 | 3 | 9 | 310 | 20 | |||
125503 | 197394 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015074.87374 | 2109163.38918 | 37.7722077659022 | -122.391238555416 | (37.7722077659022, -122.391238555416) | 14 | 3 | 9 | 310 | 20 | |||
122164 | 240945 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 192 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004100.4699 | 2097291.61636 | 37.738995525713 | -122.428353681499 | (37.738995525713, -122.428353681499) | 2 | 7 | 5 | 63 | 7 | |||
120728 | 240904 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008695.81166 | 2101451.46415 | 37.7506765068321 | -122.4127590541 | (37.7506765068321, -122.4127590541) | 2 | 4 | 7 | 28859 | 19 | |||
119933 | 197444 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013653.6839 | 2108052.2415 | 37.7690778293104 | -122.396076725459 | (37.7690778293104, -122.396076725459) | 14 | 3 | 9 | 310 | 20 | |||
119930 | 240906 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008696.38021 | 2101499.73493 | 37.7508090794957 | -122.412760500211 | (37.7508090794957, -122.412760500211) | 2 | 4 | 7 | 28859 | 19 | |||
119846 | 248016 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6009938.8027 | 2098138.85559 | 37.7416504979844 | -122.408227057349 | (37.7416504979844, -122.408227057349) | 10 | 7 | 7 | 28859 | 2 | |||
117972 | 136355 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1639 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002367.63804 | 2121224.4246 | 37.8046108851334 | -122.436057126653 | (37.8046108851334, -122.436057126653) | 13 | 9 | 1 | 57 | 17 | |||
116990 | 96391 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767136 | 6015443.33438 | 2105260.58125 | 37.7615119471268 | -122.389691369876 | (37.7615119471268, -122.389691369876) | 10 | 3 | 8 | 28856 | 29 | |
116430 | 36876 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2400 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000808.4477 | 2116625.0074 | 37.7918933985134 | -122.441122651606 | (37.7918933985134, -122.441122651606) | 13 | 6 | 1 | 29490 | 27 | |
115499 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
114006 | 240886 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6009453.92739 | 2100992.83614 | 37.7494597384933 | -122.410105040531 | (37.7494597384933, -122.410105040531) | 2 | 4 | 7 | 28859 | 19 | |||
113295 | 113637 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
113142 | 96393 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767136 | 6015446.34816 | 2105205.82612 | 37.7613617684412 | -122.389677121926 | (37.7613617684412, -122.389677121926) | 10 | 3 | 8 | 28856 | 29 | |
112931 | 46508 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 675 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | 5 | Permit Number 44677 | 6009091.30835 | 2111167.9463 | 37.777377926079 | -122.412077991228 | (37.777377926079, -122.412077991228) | 8 | 2 | 9 | 28853 | 34 | ||
112347 | 240889 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008721.46882 | 2101044.16868 | 37.7495596045891 | -122.41264153967 | (37.7495596045891, -122.41264153967) | 2 | 4 | 7 | 28859 | 19 | |||
112346 | 240946 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004126.6518 | 2097259.6464 | 37.7389092249709 | -122.428260878632 | (37.7389092249709, -122.428260878632) | 2 | 7 | 5 | 63 | 7 | |||
112344 | 94983 | Permitted Site 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54004 | 6008557 | 2113884 | 37.78480556642 | -122.414118544888 | (37.78480556642, -122.414118544888) | 7 | 10 | 9 | 28852 | 36 | ||
111952 | 240919 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 556 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002989.39478 | 2095969.72486 | 37.7353029813381 | -122.432100892951 | (37.7353029813381, -122.432100892951) | 2 | 7 | 5 | 63 | 7 | |||
109547 | 197389 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015087.56892 | 2108946.60059 | 37.7716132169039 | -122.39117948526 | (37.7716132169039, -122.39117948526) | 14 | 3 | 9 | 310 | 20 | |||
108536 | 258481 | Undocumented 4 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1721x Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008705 | 2118812 | 37.7983449620815 | -122.413955244514 | (37.7983449620815, -122.413955244514) | 5 | 1 | 10 | 308 | 21 | ||||
106042 | 197406 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015045.28656 | 2109714.70824 | 37.7737199237562 | -122.391379448623 | (37.7737199237562, -122.391379448623) | 14 | 3 | 9 | 310 | 20 | |||
103776 | 240941 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 671 Church St | 53 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004292.85412 | 2105210.63706 | 37.7607501979839 | -122.4282527371 | (37.7607501979839, -122.4282527371) | 2 | 4 | 5 | 28862 | 3 | |||
102703 | 197399 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015067.88959 | 2109305.99464 | 37.7725989413206 | -122.391272684682 | (37.7725989413206, -122.391272684682) | 14 | 3 | 9 | 310 | 20 |
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) );