trees
3,888 rows where qSpecies_id = 58 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126 | 173890 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989209 | 2097724 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | 1 | 8 | 3 | 29491 | 35 | ||||
145 | 193492 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1918 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6012632.36685 | 2102863.5529 | 37.7547739610597 | -122.399245141377 | (37.7547739610597, -122.399245141377) | 10 | 3 | 8 | 28856 | 29 | ||||
204 | 209769 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100x Pacheco St | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5994792.885 | 2099741.94773 | 37.7451924562767 | -122.460712331024 | (37.7451924562767, -122.460712331024) | 1 | 8 | 4 | 59 | 40 | |||
213 | 3891 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 23 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002162.16871 | 2108402.44463 | 37.7693933312702 | -122.435850193556 | (37.7693933312702, -122.435850193556) | 15 | 5 | 5 | 29492 | 9 | |||
219 | 131064 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1877 Greenwich St | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.7995435588443 | -122.430529985984 | (37.7995435588443, -122.430529985984) | 13 | 9 | 1 | 57 | 17 | |||
474 | 231615 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 123 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997901.04644 | 2106790.55861 | 37.7647245269317 | -122.450472936196 | (37.7647245269317, -122.450472936196) | 15 | 5 | 11 | 29492 | 9 | |||
526 | 262229 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
626 | 75627 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1345 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988723.2495 | 2097607.46 | 37.7389806270439 | -122.481543546445 | (37.7389806270439, -122.481543546445) | 1 | 8 | 3 | 29491 | 35 | |||
658 | 250807 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 276 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986224.17361 | 2114083.07798 | 37.7840724847972 | -122.491396406047 | (37.7840724847972, -122.491396406047) | 11 | 6 | 1 | 55 | 33 | |||
696 | 60808 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2075 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 8 | Permit Number 20486 | 5989723.8885 | 2101238.2089 | 37.7490078493386 | -122.478349246975 | (37.7490078493386, -122.478349246975) | 1 | 8 | 3 | 29491 | 35 | |
716 | 142310 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 660 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999215.2162 | 2110519.0944 | 37.775037270166 | -122.446195808453 | (37.775037270166, -122.446195808453) | 15 | 5 | 11 | 29492 | 16 | |||
917 | 230864 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003759.24274 | 2096500.30891 | 37.7368034614962 | -122.429477071432 | (37.7368034614962, -122.429477071432) | 2 | 7 | 5 | 63 | 7 | |||
923 | 70578 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 201 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989595.95127 | 2113926.18919 | 37.7838381644508 | -122.479719921835 | (37.7838381644508, -122.479719921835) | 11 | 6 | 2 | 55 | 26 | |||
1019 | 193499 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1400 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011700.01773 | 2101765.20682 | 37.7517061379266 | -122.402392254997 | (37.7517061379266, -122.402392254997) | 10 | 3 | 8 | 28856 | 29 | |||
1026 | 209572 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 Malta Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5999439.81114 | 2096263.84796 | 37.7359086891413 | -122.444394200825 | (37.7359086891413, -122.444394200825) | 9 | 7 | 4 | 63 | 40 | ||||
1061 | 209793 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 10 Mendosa Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993519.722 | 2101160.59093 | 37.7490143564374 | -122.465217699739 | (37.7490143564374, -122.465217699739) | 1 | 8 | 4 | 29491 | 40 | |||
1075 | 209246 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 122 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001612.99048 | 2095459.00516 | 37.7338225308765 | -122.436823072927 | (37.7338225308765, -122.436823072927) | 9 | 7 | 5 | 63 | 40 | |||
1158 | 61138 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 142 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1983 12:00:00 AM | 13 | 3x33x3 | Permit Number 20990 | 5997342.1336 | 2110018.8543 | 37.7735565931311 | -122.452639064998 | (37.7735565931311, -122.452639064998) | 15 | 5 | 11 | 29492 | 16 |
1230 | 139578 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1920 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000709.5025 | 2112107.493 | 37.7794838331764 | -122.441140745698 | (37.7794838331764, -122.441140745698) | 15 | 5 | 1 | 29490 | 16 | |||
1313 | 1946 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 12 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.7338931798791 | -122.381526972425 | (37.7338931798791, -122.381526972425) | 10 | 3 | 8 | 58 | 1 | |||
1359 | 231002 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 928 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009131.39521 | 2103568.63221 | 37.7565142139701 | -122.411402317985 | (37.7565142139701, -122.411402317985) | 2 | 4 | 7 | 28859 | 19 | |||
1514 | 230995 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 901X Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007775.46457 | 2097740.22152 | 37.740434563317 | -122.415678956745 | (37.740434563317, -122.415678956745) | 2 | 7 | 7 | 28859 | 2 | |||
1592 | 262226 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
1647 | 231666 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 51 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009187.28627 | 2097205.93175 | 37.7390467825771 | -122.410759688516 | (37.7390467825771, -122.410759688516) | 10 | 7 | 7 | 28859 | 2 | |||
1660 | 70196 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1446 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983732.7598 | 2105312.8211 | 37.7598459791451 | -122.499367343386 | (37.7598459791451, -122.499367343386) | 1 | 8 | 3 | 56 | 35 | |||
1664 | 75299 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1739X Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6005800.51839 | 2092301.46339 | 37.7253897211337 | -122.422121267299 | (37.7253897211337, -122.422121267299) | 9 | 7 | 7 | 309 | 5 | ||
1689 | 75437 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 668 18th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990378.5234 | 2110689.34453 | 37.7749961152418 | -122.476775971058 | (37.7749961152418, -122.476775971058) | 11 | 6 | 2 | 55 | 26 | |||
1855 | 140698 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 216 SHRADER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997377.5725 | 2109762.5656 | 37.772854921177 | -122.452497978404 | (37.772854921177, -122.452497978404) | 15 | 5 | 11 | 29492 | 16 | |||
1885 | 209224 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 895 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998759.0864 | 2096192.82641 | 37.7356748177208 | -122.446742618486 | (37.7356748177208, -122.446742618486) | 9 | 7 | 4 | 59 | 40 | |||
1891 | 177497 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 683 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6001012.66507 | 2089830.75462 | 37.7183345028158 | -122.438495457598 | (37.7183345028158, -122.438495457598) | 9 | 7 | 6 | 28861 | 5 | ||||
1913 | 140032 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005092.0233 | 2111947.5572 | 37.7792933441417 | -122.4259683453 | (37.7792933441417, -122.4259683453) | 7 | 9 | 11 | 28852 | 41 | |||
2017 | 60893 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 989 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1983 12:00:00 AM | 9 | Permit Number 20678 | 6008229.15288 | 2119615.93544 | 37.8005256320151 | -122.415658776857 | (37.8005256320151, -122.415658776857) | 5 | 1 | 10 | 308 | 32 | |
2039 | 231025 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3536 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006288.48394 | 2101449.03933 | 37.7505344364354 | -122.421083637602 | (37.7505344364354, -122.421083637602) | 2 | 4 | 5 | 28859 | 19 | |||
2064 | 231845 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 193 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000141.92285 | 2105642.62634 | 37.7617005898414 | -122.442639926596 | (37.7617005898414, -122.442639926596) | 15 | 5 | 5 | 28862 | 3 | |||
2086 | 74963 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2294 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989512.198 | 2099759.8574 | 37.7449363929527 | -122.478973148203 | (37.7449363929527, -122.478973148203) | 1 | 8 | 3 | 29491 | 35 | |||
2119 | 62598 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 766 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22904 | 5984487.21653 | 2110625.41876 | 37.7744771013104 | -122.497150243193 | (37.7744771013104, -122.497150243193) | 11 | 6 | 2 | 55 | 26 | |
2180 | 75223 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1739X Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6005812.42229 | 2092304.23082 | 37.7253979913003 | -122.422080313068 | (37.7253979913003, -122.422080313068) | 9 | 7 | 7 | 309 | 5 | ||
2192 | 193515 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 501 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010751.88886 | 2107396.62133 | 37.7671157675938 | -122.406067717659 | (37.7671157675938, -122.406067717659) | 8 | 4 | 8 | 28853 | 19 | |||
2342 | 209413 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1470 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992760.0479 | 2105461.84658 | 37.7607806508261 | -122.468157483703 | (37.7607806508261, -122.468157483703) | 1 | 8 | 4 | 56 | 12 | |||
2432 | 250771 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 244 32nd Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5985908.77802 | 2114250.76348 | 37.7845144656071 | -122.492499898474 | (37.7845144656071, -122.492499898474) | 11 | 6 | 1 | 55 | 33 | |||
2440 | 79187 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 45 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2019 12:00:00 AM | 3 | 3x3 | Permit Number 50829 | 6001057.44461 | 2119906.39281 | 37.8009174000823 | -122.440496575066 | (37.8009174000823, -122.440496575066) | 13 | 9 | 1 | 57 | 17 | |
2460 | 231720 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2407 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008861.251 | 2104395.7075 | 37.7587700194388 | -122.41239503463 | (37.7587700194388, -122.41239503463) | 2 | 4 | 7 | 28859 | 19 | |||
2640 | 60814 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2074 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 11 | Permit Number 20492 | 5989770.7462 | 2101244.2335 | 37.7490271113949 | -122.478187654963 | (37.7490271113949, -122.478187654963) | 1 | 8 | 3 | 29491 | 35 | |
2648 | 258774 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 841 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999900 | 2102593 | 37.7533132712937 | -122.443257593558 | (37.7533132712937, -122.443257593558) | 2 | 5 | 5 | 63 | 38 | ||||
2734 | 9598 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003113.218 | 2112071.7207 | 37.7795222347306 | -122.43282272297 | (37.7795222347306, -122.43282272297) | 15 | 9 | 11 | 29490 | 41 | |||
2757 | 60891 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 935 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1983 12:00:00 AM | 11 | Permit Number 20676 | 6008432.09813 | 2119639.75593 | 37.8006024431139 | -122.41495818879 | (37.8006024431139, -122.41495818879) | 5 | 1 | 10 | 308 | 32 | |
2800 | 60813 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2038 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 8 | Permit Number 20491 | 5989762.7135 | 2101478.8567 | 37.7496708586604 | -122.478232584296 | (37.7496708586604, -122.478232584296) | 1 | 8 | 3 | 29491 | 35 | |
2846 | 209719 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 130 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5993708.81111 | 2099601.4699 | 37.7447443078957 | -122.464450645474 | (37.7447443078957, -122.464450645474) | 1 | 8 | 4 | 29491 | 40 | |||
2904 | 71295 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1830 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x4 | 6000828.9333 | 2111756.2383 | 37.7785261792165 | -122.440702382606 | (37.7785261792165, -122.440702382606) | 15 | 5 | 11 | 29490 | 41 | ||
3091 | 19871 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 STAIRWAY33 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
3093 | 209509 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 140 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993450.39263 | 2093922.38242 | 37.7291360503751 | -122.464931835842 | (37.7291360503751, -122.464931835842) | 9 | 8 | 4 | 59 | 40 | |||
3243 | 60593 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 627 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 16 | Permit Number 20213 | 6000533.1143 | 2111193.3322 | 37.7769637316304 | -122.441685322162 | (37.7769637316304, -122.441685322162) | 15 | 5 | 11 | 29492 | 16 | |
3250 | 230859 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 156 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004565.73711 | 2097264.65624 | 37.7389478157944 | -122.426743081134 | (37.7389478157944, -122.426743081134) | 2 | 7 | 5 | 63 | 7 | |||
3275 | 58229 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1405 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 10 | Permit Number 20907 | 5999693.0226 | 2113730.4817 | 37.7838821897286 | -122.444773861918 | (37.7838821897286, -122.444773861918) | 15 | 6 | 11 | 29490 | 31 | |
3288 | 260499 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 856 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009680 | 2097105 | 37.7387972596753 | -122.409048982484 | (37.7387972596753, -122.409048982484) | 10 | 7 | 7 | 28859 | 2 | ||||
3584 | 3879 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 5 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001986.3803 | 2108685.97385 | 37.7701618451199 | -122.436478532758 | (37.7701618451199, -122.436478532758) | 15 | 5 | 5 | 29492 | 9 | |||
3693 | 60806 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2019 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 8 | Permit Number 20483 | 5989711.17 | 2101593.3234 | 37.7499821618683 | -122.478419190797 | (37.7499821618683, -122.478419190797) | 1 | 8 | 3 | 29491 | 35 | |
3805 | 250547 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 120 El Camino Del Mar | 2 | : | Tree | Private 2 | 2 | Width 4ft | 5988224.27982 | 2115368.83764 | 37.7877194875147 | -122.484571190206 | (37.7877194875147, -122.484571190206) | 11 | 6 | 1 | 55 | 33 | |||
3920 | 60883 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 770 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/1983 12:00:00 AM | 12 | Permit Number 20667 | 6009158.5873 | 2119786.8398 | 37.8010470949934 | -122.412454632639 | (37.8010470949934, -122.412454632639) | 3 | 1 | 10 | 308 | 4 | |
4028 | 70635 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 216 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989644.14952 | 2113896.17874 | 37.783758564002 | -122.479550979257 | (37.783758564002, -122.479550979257) | 11 | 6 | 2 | 55 | 26 | |||
4063 | 209755 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1 Sola Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994990.41955 | 2100663.0993 | 37.7477330707391 | -122.460096016616 | (37.7477330707391, -122.460096016616) | 1 | 8 | 4 | 29491 | 40 | |||
4134 | 62595 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 747 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 10 | Permit Number 22901 | 5984435.27123 | 2110757.77903 | 37.7748374802742 | -122.497339702401 | (37.7748374802742, -122.497339702401) | 11 | 6 | 2 | 55 | 26 | |
4202 | 181789 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3199x Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
4315 | 14730 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 880 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
4320 | 19784 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 STAIRWAY19 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
4366 | 62596 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 755 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22902 | 5984437.95928 | 2110707.0209 | 37.7746982705734 | -122.497326656151 | (37.7746982705734, -122.497326656151) | 11 | 6 | 2 | 55 | 26 | |
4533 | 209374 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1270 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5991131.49097 | 2106768.47794 | 37.7642741230703 | -122.473885208262 | (37.7642741230703, -122.473885208262) | 11 | 8 | 11 | 56 | 12 | |||
4574 | 230997 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 901X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007812.73581 | 2097738.61413 | 37.740432244864 | -122.415549973278 | (37.740432244864, -122.415549973278) | 2 | 7 | 7 | 28859 | 2 | |||
4638 | 19786 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 STAIRWAY19 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
4906 | 60490 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1100 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/1982 12:00:00 AM | 11 | Permit Number 20088 | 6001430.3552 | 2112222.0499 | 37.7798394110717 | -122.438655225862 | (37.7798394110717, -122.438655225862) | 15 | 5 | 11 | 29490 | 41 | |
4946 | 140 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1025X 14th St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1997 12:00:00 AM | 7 | 3x3 | 6002065.74261 | 2107612.5408 | 37.7672189719923 | -122.436127192841 | (37.7672189719923, -122.436127192841) | 15 | 5 | 5 | 28862 | 3 | ||
5070 | 245403 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3101 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007099.4128 | 2100504.2564 | 37.7479859570464 | -122.418212400386 | (37.7479859570464, -122.418212400386) | 2 | 7 | 7 | 28859 | 2 | |||
5078 | 70662 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 472 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010616.59856 | 2106126.86555 | 37.7636217386735 | -122.406446187457 | (37.7636217386735, -122.406446187457) | 8 | 4 | 8 | 28859 | 19 | |||
5093 | 75846 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 668 18th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5990378.249 | 2110732.47104 | 37.7751145128799 | -122.476780071876 | (37.7751145128799, -122.476780071876) | 11 | 6 | 2 | 55 | 26 | |||
5128 | 193493 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1920 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 6012617.15977 | 2102863.30837 | 37.7547724421095 | -122.399297714811 | (37.7547724421095, -122.399297714811) | 10 | 3 | 8 | 28856 | 29 | ||||
5149 | 60812 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2034 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 6 | Permit Number 20490 | 5989761.3747 | 2101510.653 | 37.7497580852088 | -122.478239538413 | (37.7497580852088, -122.478239538413) | 1 | 8 | 3 | 29491 | 35 | |
5162 | 119758 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
5322 | 137960 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1500 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005080.1263 | 2114432.0028 | 37.7861143449411 | -122.426186425546 | (37.7861143449411, -122.426186425546) | 13 | 9 | 11 | 28858 | 13 | |||
5389 | 75831 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 668 18th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990379.00421 | 2110710.57976 | 37.7750544492429 | -122.476775859685 | (37.7750544492429, -122.476775859685) | 11 | 6 | 2 | 55 | 26 | |||
5447 | 209343 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1271 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5991413.39588 | 2106783.70707 | 37.764332262448 | -122.472911299141 | (37.764332262448, -122.472911299141) | 11 | 8 | 11 | 56 | 12 | |||
5504 | 209359 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1320 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5991802.03244 | 2106294.58558 | 37.7630117564186 | -122.471531482789 | (37.7630117564186, -122.471531482789) | 1 | 8 | 11 | 56 | 12 | |||
5682 | 49721 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 382 REVISED Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/2003 12:00:00 AM | 11 | Permit Number 46531 | 6011143.70498 | 2119366.4225 | 37.8000039334839 | -122.405555610419 | (37.8000039334839, -122.405555610419) | 3 | 1 | 10 | 308 | 23 | |
5690 | 3889 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 23 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002186.05284 | 2108346.48625 | 37.7692410400757 | -122.435763575333 | (37.7692410400757, -122.435763575333) | 15 | 5 | 5 | 29492 | 9 | |||
5693 | 61211 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 113 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 10 | Permit Number 21079 | 6011211.11189 | 2096086.66275 | 37.7360867746889 | -122.403683453943 | (37.7360867746889, -122.403683453943) | 10 | 3 | 8 | 58 | 1 | |
5757 | 66794 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1234 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1991 12:00:00 AM | 12 | 3x3 | Permit Number 53181 | 6006437.45424 | 2120099.39659 | 37.801752214642 | -122.421893151548 | (37.801752214642, -122.421893151548) | 5 | 9 | 1 | 28858 | 32 | |
6019 | 231680 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 359 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006381.6018 | 2097846.54356 | 37.740648047064 | -122.420505941023 | (37.740648047064, -122.420505941023) | 2 | 7 | 7 | 28859 | 2 | |||
6022 | 209434 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1480 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994005.42424 | 2105449.78029 | 37.760819365754 | -122.463849439701 | (37.760819365754, -122.463849439701) | 1 | 5 | 11 | 56 | 12 | |||
6069 | 209268 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 32 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5999881.42598 | 2095527.25505 | 37.7339113650018 | -122.442814491289 | (37.7339113650018, -122.442814491289) | 9 | 7 | 4 | 63 | 40 | ||||
6172 | 74122 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 201 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5989595.19431 | 2113978.33334 | 37.7839812936737 | -122.479726357352 | (37.7839812936737, -122.479726357352) | 11 | 6 | 2 | 55 | 26 | |||
6255 | 72326 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1226 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5994837.87053 | 2112161.87006 | 37.7792969379819 | -122.461457013109 | (37.7792969379819, -122.461457013109) | 11 | 6 | 2 | 54 | 11 | |||
6319 | 231718 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2407 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008898 | 2104383 | 37.7587371897164 | -122.412267041051 | (37.7587371897164, -122.412267041051) | 2 | 4 | 7 | 28859 | 19 | |||
6323 | 71824 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2022 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5989759.0318 | 2101569.8945 | 37.7499206107558 | -122.478251971198 | (37.7499206107558, -122.478251971198) | 1 | 8 | 3 | 29491 | 35 | |||
6341 | 10205 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1265 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1994 12:00:00 AM | 12 | 2X2 | 6005835.28036 | 2101602.69371 | 37.7509307775347 | -122.422661770643 | (37.7509307775347, -122.422661770643) | 2 | 4 | 5 | 28859 | 19 | ||
6476 | 209581 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 130 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000521.1255 | 2094370.92061 | 37.7307727877238 | -122.440519953835 | (37.7307727877238, -122.440519953835) | 9 | 7 | 4 | 63 | 40 | |||
6492 | 74673 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1040X Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989578.5693 | 2099732.6241 | 37.7448654714378 | -122.47874165962 | (37.7448654714378, -122.47874165962) | 1 | 8 | 3 | 29491 | 35 | |||
6636 | 75056 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1739X Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 4x4 | 6005836.26564 | 2092311.52216 | 37.7254193565072 | -122.421998406407 | (37.7254193565072, -122.421998406407) | 9 | 7 | 7 | 309 | 5 | ||
6658 | 73145 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 560 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5991294.46609 | 2111590.92928 | 37.777524708179 | -122.473673341879 | (37.777524708179, -122.473673341879) | 11 | 6 | 2 | 54 | 26 | |||
6843 | 60544 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 662 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 14 | Permit Number 20154 | 5985391.24868 | 2111355.99537 | 37.7765359942377 | -122.49407692427 | (37.7765359942377, -122.49407692427) | 11 | 6 | 2 | 55 | 26 | |
6904 | 28344 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3101 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2002 12:00:00 AM | 6 | 3X3 | 6007061.5028 | 2100435.1263 | 37.7477940074622 | -122.4183385911 | (37.7477940074622, -122.4183385911) | 2 | 7 | 7 | 28859 | 2 | ||
6995 | 9735 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 727X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6005653.63672 | 2112026.60995 | 37.7795421273786 | -122.424031111893 | (37.7795421273786, -122.424031111893) | 7 | 9 | 11 | 28852 | 41 |
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) );