trees
430 rows where qSpecies_id = 99 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
136998 | 6416 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 400X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 6x5 | 5995602.32868 | 2113744.52068 | 37.7836864443545 | -122.458927071616 | (37.7836864443545, -122.458927071616) | 11 | 6 | 1 | 54 | 31 | |||
139838 | 1438 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 5 | 5995477.38208 | 2115292.89339 | 37.7879306760788 | -122.459471511755 | (37.7879306760788, -122.459471511755) | 11 | 6 | 1 | 54 | 11 | |||
142118 | 124672 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | Width 4ft | 5995591.07711 | 2113866.14003 | 37.7840197317356 | -122.458974806266 | (37.7840197317356, -122.458974806266) | 11 | 6 | 1 | 54 | 31 | |||
143170 | 1543 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995618.1476548 | 2113146.4510222 | 37.7820452142622 | -122.458829030078 | (37.7820452142622, -122.458829030078) | 11 | 6 | 1 | 54 | 31 | |||
146234 | 1525 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 439 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5X7 | 5995548.96018 | 2113291.48375 | 37.7824394582911 | -122.459078890487 | (37.7824394582911, -122.459078890487) | 11 | 6 | 2 | 54 | 11 | |||
149942 | 123483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995662.44998 | 2111958.25695 | 37.7787852957742 | -122.458589724568 | (37.7787852957742, -122.458589724568) | 11 | 6 | 2 | 54 | 16 | ||||
152803 | 1531 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 499 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995560.27463 | 2113085.81754 | 37.7818754042369 | -122.459024851411 | (37.7818754042369, -122.459024851411) | 11 | 6 | 2 | 54 | 11 | |||
152819 | 124688 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995612.53793 | 2113341.5687 | 37.7825806328494 | -122.458862568059 | (37.7825806328494, -122.458862568059) | 11 | 6 | 1 | 54 | 31 | |||
153831 | 124641 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995529.17868 | 2115583.09769 | 37.7887304767053 | -122.459313330112 | (37.7887304767053, -122.459313330112) | 11 | 6 | 1 | 54 | 31 | |||
155276 | 1551 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 530 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995634.85993 | 2112642.48366 | 37.7806624148094 | -122.458734717129 | (37.7806624148094, -122.458734717129) | 11 | 6 | 2 | 54 | 16 | |||
156611 | 253429 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2198 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x7 | 5992046 | 2112030 | 37.7787737730441 | -122.471105555235 | (37.7787737730441, -122.471105555235) | 11 | 6 | 2 | 54 | 11 | ||||
156814 | 123644 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 499 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995555.16132 | 2113176.03479 | 37.7821228227737 | -122.459049075391 | (37.7821228227737, -122.459049075391) | 11 | 6 | 2 | 54 | 11 | |||
157104 | 1434 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | 11 | 6 | 1 | 54 | 31 | |||
159736 | 124642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | 11 | 6 | 1 | 54 | 31 | |||
161310 | 137073 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5997662.02457 | 2115459.05462 | 37.7885122812527 | -122.451925075987 | (37.7885122812527, -122.451925075987) | 11 | 6 | 1 | 54 | 31 | |||
164973 | 1430 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5 | 5995476.6114 | 2115563.93405 | 37.7886748361207 | -122.459493815623 | (37.7886748361207, -122.459493815623) | 11 | 6 | 1 | 54 | 11 | |||
168411 | 1542 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995618.1476548 | 2113146.4510222 | 37.7820452142622 | -122.458829030078 | (37.7820452142622, -122.458829030078) | 11 | 6 | 1 | 54 | 31 | |||
169822 | 1581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 629 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995601.12395 | 2111917.66113 | 37.7786703056802 | -122.458798934123 | (37.7786703056802, -122.458798934123) | 11 | 6 | 2 | 54 | 11 | |||
170220 | 1597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 714 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995688.036 | 2111228.67679 | 37.7767835321697 | -122.458448388127 | (37.7767835321697, -122.458448388127) | 11 | 6 | 2 | 54 | 16 | |||
170778 | 1526 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 440 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 5995608.48873 | 2113422.41383 | 37.7828023792183 | -122.458882431606 | (37.7828023792183, -122.458882431606) | 11 | 6 | 1 | 54 | 31 | |||
176937 | 137070 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997942.37701 | 2116329.50618 | 37.7909183634316 | -122.451017898383 | (37.7909183634316, -122.451017898383) | 11 | 6 | 1 | 54 | 31 | |||
176981 | 1420 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3x3 | 5995529.5957 | 2115606.06371 | 37.7887935591586 | -122.459313551095 | (37.7887935591586, -122.459313551095) | 11 | 6 | 1 | 54 | 31 | |||
178234 | 1510 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 369 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 5995536.86997 | 2113765.1567 | 37.7837393424086 | -122.459155027191 | (37.7837393424086, -122.459155027191) | 11 | 6 | 2 | 54 | 11 | |||
181960 | 123470 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 778 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5995383.59468 | 2110411.06724 | 37.7745210919414 | -122.459442307531 | (37.7745210919414, -122.459442307531) | 11 | 6 | 2 | 54 | 11 | |||
185164 | 1474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 234 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x5 | 5995562.8915 | 2114652.71711 | 37.7861778408698 | -122.459129293157 | (37.7861778408698, -122.459129293157) | 11 | 6 | 1 | 54 | 31 | |||
186153 | 105882 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5997612.13513 | 2115509.12693 | 37.7886469088657 | -122.45210129905 | (37.7886469088657, -122.45210129905) | 11 | 6 | 1 | 54 | 31 | ||||
188888 | 1435 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 5 | 5995475.98082 | 2115376.20265 | 37.7881593402184 | -122.459482395726 | (37.7881593402184, -122.459482395726) | 11 | 6 | 1 | 54 | 11 | |||
190088 | 1432 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 5 | 5995472.27833 | 2115471.9588 | 37.7884220478225 | -122.45950214341 | (37.7884220478225, -122.45950214341) | 11 | 6 | 1 | 54 | 11 | |||
191957 | 123481 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995659.66948 | 2112025.6512 | 37.7789701827075 | -122.458604223385 | (37.7789701827075, -122.458604223385) | 11 | 6 | 2 | 54 | 16 | ||||
1798 | 242795 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1671 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009731.24755 | 2099988.43526 | 37.7467174150944 | -122.409075193563 | (37.7467174150944, -122.409075193563) | 2 | 7 | 7 | 28859 | 2 | |||
2820 | 899 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418 | (37.7307693064514, -122.43007470418) | 9 | 7 | 6 | 28861 | 25 | |||
6012 | 16704 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | 5x6 | 6001608.07304 | 2092347.28192 | 37.7252781710498 | -122.43661741688 | (37.7252781710498, -122.43661741688) | 9 | 7 | 6 | 28861 | 25 | |||
6804 | 1081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | 9 | 7 | 6 | 28861 | 25 | |||
10682 | 978 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001786.79947 | 2092741.59351 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | 9 | 7 | 6 | 28861 | 25 | |||
12102 | 180591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.7228723703333 | -122.438023911598 | (37.7228723703333, -122.438023911598) | 9 | 7 | 6 | 28861 | 25 | |||
12178 | 1048 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | 9 | 7 | 6 | 28861 | 25 | ||||
14050 | 180592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 4ft | 6001143.73267 | 2091406.40414 | 37.72266833577 | -122.438155223402 | (37.72266833577, -122.438155223402) | 9 | 7 | 6 | 28861 | 25 | |||
15479 | 896 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 4X4 | 6003365.90456 | 2094243.14139 | 37.7305835136383 | -122.43067599245 | (37.7305835136383, -122.43067599245) | 9 | 7 | 6 | 28861 | 25 | |||
22805 | 914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1233 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X5 | 6003058.45033 | 2094142.01954 | 37.7302884326438 | -122.431731689776 | (37.7302884326438, -122.431731689776) | 9 | 7 | 6 | 28861 | 25 | |||
23519 | 180581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6002394.23037 | 2093854.80651 | 37.7294621373592 | -122.434007462878 | (37.7294621373592, -122.434007462878) | 9 | 7 | 5 | 28861 | 25 | |||
26642 | 1061 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000441.22371 | 2090128.46046 | 37.7191194136535 | -122.440492025318 | (37.7191194136535, -122.440492025318) | 9 | 7 | 6 | 28861 | 25 | |||
27401 | 912 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1229 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003089.95028 | 2094152.43682 | 37.7303188216593 | -122.431623533692 | (37.7303188216593, -122.431623533692) | 9 | 7 | 6 | 28861 | 25 | |||
28708 | 1010 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1840X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6001180.26428 | 2091487.57144 | 37.7228932804007 | -122.438034753125 | (37.7228932804007, -122.438034753125) | 9 | 7 | 6 | 28861 | 25 | |||
30682 | 970 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4X4 | 6001869.51123 | 2092911.87236 | 37.7268432620915 | -122.435754028151 | (37.7268432620915, -122.435754028151) | 9 | 7 | 6 | 28861 | 25 | |||
32835 | 1054 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | 9 | 7 | 6 | 28861 | 25 | |||
35213 | 1085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999963.70084 | 2089791.48987 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | 9 | 7 | 6 | 28861 | 25 | |||
46333 | 21830 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1419X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X6 | 6002361.46709 | 2093663.80125 | 37.7289358208429 | -122.434107079856 | (37.7289358208429, -122.434107079856) | 9 | 7 | 6 | 28861 | 25 | |||
47119 | 180584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003732.95256 | 2094463.14814 | 37.7312083905422 | -122.429422736186 | (37.7312083905422, -122.429422736186) | 9 | 7 | 5 | 28861 | 25 | |||
49035 | 1182 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
49417 | 997 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1693 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6001548.3914 | 2092219.76431 | 37.7249246448287 | -122.436814605813 | (37.7249246448287, -122.436814605813) | 9 | 7 | 6 | 28861 | 25 | |||
51308 | 242791 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1001 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6005175.70924 | 2096892.88162 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | 2 | 7 | 5 | 28859 | 2 | ||||
52619 | 1032 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
54348 | 933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1294X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6002802.17626 | 2094143.63343 | 37.7302783338422 | -122.432617778446 | (37.7302783338422, -122.432617778446) | 9 | 7 | 5 | 28861 | 25 | |||
55899 | 180586 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001346.13618 | 2093162.98872 | 37.7275030272355 | -122.437581294937 | (37.7275030272355, -122.437581294937) | 9 | 7 | 6 | 28861 | 25 | |||
56237 | 1042 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1999X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6000738.08152 | 2090455.78835 | 37.7200350812737 | -122.439489356062 | (37.7200350812737, -122.439489356062) | 9 | 7 | 6 | 28861 | 25 | |||
56999 | 929 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1286X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002834.53778 | 2094157.03866 | 37.7303169767627 | -122.432506857514 | (37.7303169767627, -122.432506857514) | 9 | 7 | 5 | 28861 | 25 | |||
58765 | 242794 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 4 | Median : Yard | Tree | DPW 1 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | 2 | 7 | 7 | 28859 | 2 | ||||
61972 | 19303 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.441033210291 | (37.7186921269443, -122.441033210291) | 9 | 7 | 6 | 28861 | 25 | |||
62520 | 936 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.03009 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | 9 | 7 | 6 | 28861 | 25 | ||
63749 | 938 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6002521.94299 | 2093864.98404 | 37.7294973296157 | -122.433566675476 | (37.7294973296157, -122.433566675476) | 9 | 7 | 6 | 28861 | 25 | |||
65775 | 180589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6003010.99045 | 2094126.19284 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | 9 | 7 | 6 | 28861 | 25 | |||
66372 | 883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | |||
69092 | 885 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||||
69972 | 180587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1473 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6002172.86661 | 2093413.14517 | 37.7282368704302 | -122.434741167586 | (37.7282368704302, -122.434741167586) | 9 | 7 | 6 | 28861 | 25 | |||
70794 | 242793 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | 2 | 7 | 7 | 28859 | 2 | |||
74694 | 51907 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
74945 | 16703 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 43 | 5x6 | 6001597.82921 | 2092328.38749 | 37.7252257090852 | -122.436651476894 | (37.7252257090852, -122.436651476894) | 9 | 7 | 6 | 28861 | 25 | |||
91731 | 940 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1331 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6002472.82123 | 2093812.78737 | 37.7293512221746 | -122.433732764948 | (37.7293512221746, -122.433732764948) | 9 | 7 | 6 | 28861 | 25 | |||
95286 | 180588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1447 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6002392.55611 | 2093716.48474 | 37.7290822421508 | -122.434003367375 | (37.7290822421508, -122.434003367375) | 9 | 7 | 6 | 28861 | 25 | |||
98146 | 915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003037.51053 | 2094134.66319 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | 9 | 7 | 6 | 28861 | 25 | |||
101438 | 108311 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 439x ARLINGTON ST | 1 | Back Yard : Yard | Tree | Private 2 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329169 | (37.7354814316621, -122.42878329169) | 2 | 7 | 5 | 63 | 7 | |||||
107664 | 1035 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
107794 | 180585 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001325.27813 | 2093179.51545 | 37.7275472199251 | -122.43765458429 | (37.7275472199251, -122.43765458429) | 9 | 7 | 6 | 28861 | 25 | |||
113992 | 51906 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
119308 | 180582 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | 9 | 7 | 5 | 28861 | 25 | |||
121303 | 4850 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
127111 | 256855 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1777 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001446 | 2091921 | 37.7240984859228 | -122.437147179411 | (37.7240984859228, -122.437147179411) | 9 | 7 | 6 | 28861 | 25 | ||||
128474 | 974 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X5 | 6001933.92809 | 2093061.63022 | 37.7272581220521 | -122.435542049851 | (37.7272581220521, -122.435542049851) | 9 | 7 | 6 | 28861 | 25 | |||
135020 | 979 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6001800.3284 | 2092768.49495 | 37.7264456502383 | -122.435982936161 | (37.7264456502383, -122.435982936161) | 9 | 7 | 6 | 28861 | 25 | |||
135732 | 4849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1469X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X6 | 6002249.52444 | 2093516.68285 | 37.7285255132222 | -122.434483558574 | (37.7285255132222, -122.434483558574) | 9 | 7 | 6 | 28861 | 25 | |||
135925 | 1181 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
136001 | 180590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1159 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6003628.44812 | 2094335.41976 | 37.7308517598817 | -122.429774919684 | (37.7308517598817, -122.429774919684) | 9 | 7 | 6 | 28861 | 25 | |||
138849 | 1058 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2055X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000480.4143 | 2090166.82631 | 37.719226989106 | -122.440359308841 | (37.719226989106, -122.440359308841) | 9 | 7 | 6 | 28861 | 25 | |||
139940 | 180580 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1282 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6002752.91911 | 2094123.24132 | 37.7302195481937 | -122.432786610727 | (37.7302195481937, -122.432786610727) | 9 | 7 | 5 | 28861 | 25 | |||
140491 | 1027 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1965X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 31 | 3X3 | 6000825.64245 | 2090608.45865 | 37.7204592623287 | -122.439197625247 | (37.7204592623287, -122.439197625247) | 9 | 7 | 6 | 28861 | 25 | ||
147602 | 939 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | 9 | 7 | 6 | 28861 | 25 | |||
147678 | 884 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 24 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||
147868 | 1060 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2059X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000457.16463 | 2090146.24433 | 37.7191691518296 | -122.440438198589 | (37.7191691518296, -122.440438198589) | 9 | 7 | 6 | 28861 | 25 | |||
149997 | 1001 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | 9 | 7 | 6 | 28861 | 25 | |||
151809 | 180583 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6003761.56491 | 2094470.84041 | 37.7312311316907 | -122.429324366526 | (37.7312311316907, -122.429324366526) | 9 | 7 | 5 | 28861 | 25 | |||
152021 | 1029 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X6 | 6000859.82003 | 2090688.3349 | 37.7206805292285 | -122.439085206354 | (37.7206805292285, -122.439085206354) | 9 | 7 | 6 | 28861 | 25 | |||
153370 | 1030 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | 3X6 | 6000847.46445 | 2090663.09263 | 37.7206105166164 | -122.439126107438 | (37.7206105166164, -122.439126107438) | 9 | 7 | 6 | 28861 | 25 | |||
155781 | 1014 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1852X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6001135.54804 | 2091400.82126 | 37.7226525409555 | -122.438183116075 | (37.7226525409555, -122.438183116075) | 9 | 7 | 6 | 28861 | 25 | |||
161940 | 1052 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2039X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000548.43841 | 2090229.36669 | 37.719402583767 | -122.44012865812 | (37.719402583767, -122.44012865812) | 9 | 7 | 6 | 28861 | 25 | |||
165558 | 1066 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2075X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000333.40297 | 2090026.65578 | 37.7188337409507 | -122.440857420165 | (37.7188337409507, -122.440857420165) | 9 | 7 | 6 | 28861 | 25 | |||
167729 | 1056 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2049X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000499.53685 | 2090188.32691 | 37.7192871136702 | -122.440294750677 | (37.7192871136702, -122.440294750677) | 9 | 7 | 6 | 28861 | 25 | |||
174705 | 180593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2136 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6000017.35738 | 2089840.46995 | 37.7183045122206 | -122.441936504777 | (37.7183045122206, -122.441936504777) | 9 | 7 | 6 | 28861 | 25 | |||
176801 | 22540 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1441X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 12X6 | 6002335.85354 | 2093628.68187 | 37.728837937275 | -122.434193118021 | (37.728837937275, -122.434193118021) | 9 | 7 | 6 | 28861 | 25 | |||
184825 | 22541 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1396X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6002380.38751 | 2093819.80205 | 37.7293652374447 | -122.434052817677 | (37.7293652374447, -122.434052817677) | 9 | 7 | 6 | 28861 | 25 | |||
186626 | 917 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1245 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003003.64796 | 2094102.53816 | 37.7301769190865 | -122.431918330789 | (37.7301769190865, -122.431918330789) | 9 | 7 | 6 | 28861 | 25 |
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) );