trees
1,626 rows where qSpecies_id = 53 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87782 | 21807 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
87820 | 20116 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
88644 | 4629 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.408591136664 | (37.7990784717377, -122.408591136664) | 3 | 1 | 10 | 308 | 4 | |||
89072 | 18459 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | 10 | 4 | 8 | 28859 | 19 | |||
89782 | 4755 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
90207 | 6932 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 780762 | 6004980.8762 | 2110598.20876 | 37.7755820815859 | -122.426256755638 | (37.7755820815859, -122.426256755638) | 7 | 9 | 11 | 28852 | 10 | ||
90420 | 124731 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 198X Division St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
90466 | 21986 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
90745 | 18351 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 469 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010382.7073264 | 2106125.7302845 | 37.7636055342277 | -122.407255067708 | (37.7636055342277, -122.407255067708) | 8 | 4 | 8 | 28859 | 19 | |||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
91800 | 19370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
91802 | 8767 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
93022 | 5387 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 325X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
93249 | 9942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | 3 | 1 | 10 | 308 | 4 | |||
93569 | 7144 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 685X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
93727 | 26951 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 5x6 | 6002681.79801 | 2114441.89018 | 37.7860056439611 | -122.434484700269 | (37.7860056439611, -122.434484700269) | 13 | 9 | 11 | 29490 | 27 | |||
93831 | 7281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1820X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003034.84406 | 2114579.8244 | 37.7864044107242 | -122.433273117504 | (37.7864044107242, -122.433273117504) | 13 | 9 | 11 | 29490 | 27 | |||
93895 | 173772 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2235 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002649 | 2107045 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | 15 | 5 | 5 | 28862 | 3 | ||||
94050 | 6131 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X ELLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006542 | 2113585 | 37.7838712020833 | -122.421068560353 | (37.7838712020833, -122.421068560353) | 7 | 9 | 11 | 28858 | 41 | |||
94054 | 21691 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003627.3299403 | 2114521.0871369 | 37.7862767266181 | -122.431219072895 | (37.7862767266181, -122.431219072895) | 13 | 9 | 11 | 29490 | 13 | |||
94426 | 23139 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x3 | 6010454.05392 | 2118948.49862 | 37.798817830036 | -122.407912589535 | (37.798817830036, -122.407912589535) | 3 | 1 | 10 | 308 | 23 | |||
95502 | 16899 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005035.08833 | 2110252.02045 | 37.7746345969303 | -122.426044572686 | (37.7746345969303, -122.426044572686) | 7 | 9 | 11 | 28852 | 10 | |||
95868 | 19217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1103X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002080.8485 | 2110141.50629 | 37.7741637433971 | -122.436255949697 | (37.7741637433971, -122.436255949697) | 15 | 5 | 11 | 29492 | 10 | |||
97139 | 15172 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010497.86985 | 2112769.44604 | 37.7818540873698 | -122.40732513932 | (37.7818540873698, -122.40732513932) | 14 | 2 | 9 | 28853 | 34 | |||
97500 | 1685 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 452X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994164.03145 | 2111506.7878 | 37.7774594509207 | -122.463740525584 | (37.7774594509207, -122.463740525584) | 11 | 6 | 2 | 54 | 11 | |||
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
98303 | 23537 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005731.47426 | 2119901.45589 | 37.8011688807257 | -122.424322084799 | (37.8011688807257, -122.424322084799) | 13 | 9 | 1 | 28858 | 32 | |||
98753 | 18298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 35X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010274.737783 | 2108072.9305947 | 37.7689460585554 | -122.407765812226 | (37.7689460585554, -122.407765812226) | 8 | 4 | 8 | 28853 | 19 | |||
99014 | 117566 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
99392 | 94300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||
99621 | 17017 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1047 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001994.16718 | 2109794.13406 | 37.7732050204621 | -122.436530926895 | (37.7732050204621, -122.436530926895) | 15 | 5 | 11 | 29492 | 9 | |||
100106 | 7244 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 4x4 | 6003093.09301 | 2114182.05294 | 37.785315535228 | -122.433043161197 | (37.785315535228, -122.433043161197) | 13 | 9 | 11 | 29490 | 13 | |||
101356 | 18317 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
101481 | 7279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1803 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x6 | 6002990.14459 | 2114551.19489 | 37.7863232654697 | -122.43342571959 | (37.7863232654697, -122.43342571959) | 13 | 9 | 11 | 29490 | 27 | |||
102040 | 7235 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1055 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003361.88401 | 2111924.41801 | 37.7791318785406 | -122.431951960454 | (37.7791318785406, -122.431951960454) | 15 | 9 | 11 | 29490 | 41 | |||
102193 | 6752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017539.76894 | 2096719.16796 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | 10 | 3 | 8 | 58 | 1 | |||
103171 | 4672 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 659 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6009562.16476 | 2119705.53614 | 37.8008464951643 | -122.411052329729 | (37.8008464951643, -122.411052329729) | 3 | 1 | 10 | 308 | 4 | |||
103514 | 4559 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 10x6 | 6005144.0595933 | 2101075.0968609 | 37.7494430966122 | -122.425014546007 | (37.7494430966122, -122.425014546007) | 2 | 4 | 5 | 28862 | 22 | |||
103656 | 28250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
103903 | 7712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 47 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006492.59831 | 2110356.24747 | 37.7750030463236 | -122.421010148365 | (37.7750030463236, -122.421010148365) | 7 | 9 | 11 | 28852 | 10 | |||
104299 | 21960 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2525 03RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | 10 | 3 | 8 | 28856 | 29 | |||
104538 | 21643 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1653 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004694.8905536 | 2114669.5021072 | 37.786744676998 | -122.427536165445 | (37.786744676998, -122.427536165445) | 13 | 9 | 11 | 28858 | 13 | |||
104550 | 21748 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002560.9316389 | 2114541.9034523 | 37.786273393243 | -122.434910019678 | (37.786273393243, -122.434910019678) | 13 | 9 | 11 | 29490 | 27 | |||
104659 | 124727 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 198X Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
105017 | 13309 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 300X Lyon St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | 15 | 5 | 11 | 29492 | 16 | |||
105043 | 6286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1480 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003841.85446 | 2113208.69765 | 37.7826853888603 | -122.430383202835 | (37.7826853888603, -122.430383202835) | 7 | 9 | 11 | 29490 | 41 | |||
105287 | 18158 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1380X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005557.7830834 | 2114491.983444 | 37.7863060232386 | -122.424538126694 | (37.7863060232386, -122.424538126694) | 13 | 9 | 1 | 28858 | 41 | |||
105646 | 10464 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1584 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998533.97425 | 2108659.62994 | 37.7698927281656 | -122.448418425141 | (37.7698927281656, -122.448418425141) | 15 | 5 | 11 | 29492 | 9 | |||
105748 | 21991 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x6 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
106316 | 17014 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002208.6674 | 2109818.85859 | 37.7732850945599 | -122.43579071263 | (37.7732850945599, -122.43579071263) | 15 | 5 | 11 | 29492 | 9 | |||
106831 | 7272 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003036.70673 | 2114326.97944 | 37.78571026818 | -122.433248599687 | (37.78571026818, -122.433248599687) | 13 | 9 | 11 | 29490 | 13 | |||
107261 | 18696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
107993 | 17088 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1611 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5999244.55181 | 2109378.06634 | 37.77190597325 | -122.446012243601 | (37.77190597325, -122.446012243601) | 15 | 5 | 11 | 29492 | 9 | |||
108315 | 251688 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008132 | 2115128 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | 13 | 1 | 10 | 28858 | 21 | ||||
108637 | 27712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | |||
109108 | 21697 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | |||
109251 | 17295 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007087.86369 | 2109540.24307 | 37.7727960300261 | -122.418893105705 | (37.7727960300261, -122.418893105705) | 8 | 2 | 9 | 28853 | 19 | |||
109285 | 11031 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1469 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6007466.43149 | 2117407.25122 | 37.7944182331434 | -122.418141434433 | (37.7944182331434, -122.418141434433) | 5 | 1 | 10 | 28858 | 32 | |||
109336 | 6287 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1480 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003811.10608 | 2113208.12243 | 37.7826820676681 | -122.430489538043 | (37.7826820676681, -122.430489538043) | 7 | 9 | 11 | 29490 | 41 | |||
109441 | 127217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 6 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | Permit Number 782825 | 5999928.92975 | 2117120.95639 | 37.7932050075467 | -122.444201430254 | (37.7932050075467, -122.444201430254) | 13 | 9 | 1 | 57 | 27 | ||
109776 | 23705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004026.4448 | 2110044.61455 | 37.7740080535371 | -122.429518876644 | (37.7740080535371, -122.429518876644) | 7 | 9 | 11 | 29492 | 10 | |||
109824 | 17315 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
110376 | 25995 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191 | (37.7364675981514, -122.39375225191) | 10 | 3 | 8 | 58 | 1 | |||
110637 | 7234 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1035 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003369.22487 | 2111874.56942 | 37.7789954228838 | -122.431923005031 | (37.7789954228838, -122.431923005031) | 15 | 9 | 11 | 29490 | 41 | |||
110927 | 10713 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003918.21533 | 2113256.44585 | 37.7828208186367 | -122.430122434181 | (37.7828208186367, -122.430122434181) | 7 | 9 | 11 | 29490 | 41 | |||
111324 | 7153 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003550.62034 | 2110877.34065 | 37.7762675615733 | -122.431224284875 | (37.7762675615733, -122.431224284875) | 7 | 9 | 11 | 29492 | 10 | |||
111411 | 253520 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643 | 2120264 | 37.8022157634914 | -122.42119356192 | (37.8022157634914, -122.42119356192) | 5 | 1 | 1 | 28858 | 32 | ||
112012 | 2718 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | 13 | 9 | 11 | 29490 | 27 | |||
112841 | 1679 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994545.07613 | 2111468.1594 | 37.7773753373943 | -122.462419573309 | (37.7773753373943, -122.462419573309) | 11 | 6 | 2 | 54 | 11 | |||
112959 | 21977 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015880.48539 | 2103611.32219 | 37.7570076642803 | -122.388064334928 | (37.7570076642803, -122.388064334928) | 10 | 3 | 8 | 28856 | 29 | |||
112969 | 21752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
113146 | 111793 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55X Sherman St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6010868.84129 | 2110834.34163 | 37.7765614981606 | -122.405905386452 | (37.7765614981606, -122.405905386452) | 14 | 2 | 9 | 28853 | 34 | |||
113219 | 16946 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 609 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
113415 | 17294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007138.45925 | 2109591.54151 | 37.7729397321212 | -122.418721728138 | (37.7729397321212, -122.418721728138) | 8 | 2 | 9 | 28853 | 19 | |||
113625 | 13308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 300X Lyon St | 1 | Median : Cutout | Tree | DPW 1 | 6 | 100 | 6000275.5456666 | 2109923.7813264 | 37.7734631881999 | -122.442485158742 | (37.7734631881999, -122.442485158742) | 15 | 5 | 11 | 29492 | 16 | |||
113684 | 13012 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 6010380.84909 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | 3 | 1 | 10 | 308 | 23 | |||
115017 | 4281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | 2 | 4 | 5 | 63 | 22 | |||
115288 | 107652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
115585 | 13186 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2051X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002574.7502816 | 2119473.5963948 | 37.7998153348368 | -122.435215088035 | (37.7998153348368, -122.435215088035) | 13 | 9 | 1 | 57 | 17 | |||
115602 | 550 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2899 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009498.42946 | 2102171.88233 | 37.7526996313063 | -122.410034375932 | (37.7526996313063, -122.410034375932) | 2 | 4 | 7 | 28859 | 19 | |||
116014 | 107653 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
116714 | 59226 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | 11 | 6 | 2 | 54 | 11 | ||
117462 | 12246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 501 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004973.20209 | 2110637.42143 | 37.775689316239 | -122.426286094705 | (37.775689316239, -122.426286094705) | 7 | 9 | 11 | 28852 | 10 | ||
118179 | 21987 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.388043123198 | (37.7568613347581, -122.388043123198) | 10 | 3 | 8 | 28856 | 29 | |||
119084 | 173642 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 657 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
119249 | 648 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
119311 | 4652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
119421 | 7274 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002992.2982 | 2114509.63366 | 37.7862092710508 | -122.433415297593 | (37.7862092710508, -122.433415297593) | 13 | 9 | 11 | 29490 | 27 | |||
119461 | 11088 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
119516 | 23795 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1119 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003757.7161484 | 2112550.5292093 | 37.7808734562577 | -122.430627305455 | (37.7808734562577, -122.430627305455) | 15 | 9 | 11 | 29490 | 41 | |||
119793 | 7270 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 4X4 | 6003016.86176 | 2114375.85752 | 37.7858433492106 | -122.433320751484 | (37.7858433492106, -122.433320751484) | 13 | 9 | 11 | 29490 | 13 | |||
120409 | 7217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
120455 | 1669 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
120524 | 9575 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003461.41634 | 2112120.31079 | 37.7796753933958 | -122.431621626992 | (37.7796753933958, -122.431621626992) | 15 | 9 | 11 | 29490 | 41 | |||
120658 | 13201 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
120727 | 27489 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2109 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005954.70257 | 2117589.1006 | 37.7948323414476 | -122.42338513917 | (37.7948323414476, -122.42338513917) | 13 | 9 | 1 | 28858 | 27 | |||
120981 | 95046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
121115 | 94298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
121432 | 624 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3157 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6007970.52254 | 2102065.21548 | 37.752320993709 | -122.415310615518 | (37.752320993709, -122.415310615518) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );