trees
430 rows where qSpecies_id = 99 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193895 | 215604 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 38 | : | Tree | Private 2 | 3 | Width 0ft | 5991153.81619 | 2090748.1801 | 37.7202877943298 | -122.472639873854 | (37.7202877943298, -122.472639873854) | 9 | 8 | 4 | 64 | 40 | |||
193502 | 215611 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 51 | : | Tree | Private 2 | 3 | Width 0ft | 5991153.406 | 2090660.89558 | 37.7200481088127 | -122.472634931171 | (37.7200481088127, -122.472634931171) | 9 | 8 | 4 | 64 | 40 | |||
193226 | 242792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 37 | 6003987.76148 | 2095934.32271 | 37.7352623274905 | -122.428646648224 | (37.7352623274905, -122.428646648224) | 2 | 7 | 5 | 28861 | 7 | ||||
192958 | 6278 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
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 | ||||
191892 | 137078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | 5 | 1 | 10 | 308 | 21 | |||
191151 | 900 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1167 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003509.89866 | 2094295.64409 | 37.7307358309933 | -122.43018192766 | (37.7307358309933, -122.43018192766) | 9 | 7 | 6 | 28861 | 25 | |||
190541 | 93023 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
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 | |||
189616 | 137075 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 1 | : | Tree | Private 2 | 24 | Width 5ft | 6004617.55273 | 2110839.21576 | 37.776223284701 | -122.42753075415 | (37.776223284701, -122.42753075415) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
188047 | 1025 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1948 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000854.43502 | 2090852.74185 | 37.7211316470959 | -122.439115597724 | (37.7211316470959, -122.439115597724) | 9 | 7 | 6 | 28861 | 25 | |||
187564 | 1051 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2035X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6000572.81835 | 2090254.90744 | 37.7194741008396 | -122.440046216346 | (37.7194741008396, -122.440046216346) | 9 | 7 | 6 | 28861 | 25 | |||
187041 | 215631 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 74 | : | Tree | Private 2 | 4 | Width 0ft | 5991145.11917 | 2090589.24121 | 37.7198508838856 | -122.472658354026 | (37.7198508838856, -122.472658354026) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
184791 | 1218 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3575X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5993629.70146 | 2087487.19649 | 37.711476919919 | -122.463845046869 | (37.711476919919, -122.463845046869) | 9 | 8 | 4 | 64 | 24 | |||
183862 | 215643 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 86 | : | Tree | Private 2 | 7 | Width 0ft | 5991150.43358 | 2090559.55238 | 37.7197696732999 | -122.472637820687 | (37.7197696732999, -122.472637820687) | 9 | 8 | 4 | 64 | 40 | |||
183694 | 2933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1834 California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | 13 | 9 | 1 | 28858 | 27 | ||
183540 | 29914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
183223 | 19107 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
182658 | 19065 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 179 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5995218.7218404 | 2087397.9242615 | 37.7113232420063 | -122.458346556584 | (37.7113232420063, -122.458346556584) | 9 | 8 | 6 | 28861 | 24 | |||
182532 | 26779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
180812 | 215634 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 77 | : | Tree | Private 2 | 4 | Width 0ft | 5991150.93218 | 2090583.20344 | 37.7198346421452 | -122.472637820701 | (37.7198346421452, -122.472637820701) | 9 | 8 | 4 | 64 | 40 | |||
179933 | 11874 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
179277 | 215591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 233 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994635.36944 | 2087388.76073 | 37.7112645410012 | -122.460362092762 | (37.7112645410012, -122.460362092762) | 9 | 8 | 6 | 28861 | 24 | |||
178273 | 175047 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5991389.20246 | 2088805.53688 | 37.7149673943122 | -122.47168473357 | (37.7149673943122, -122.47168473357) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
178189 | 215608 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 2 | Width 0ft | 5991156.01629 | 2090675.51857 | 37.7200884110352 | -122.472626973968 | (37.7200884110352, -122.472626973968) | 9 | 8 | 4 | 64 | 40 | |||
177921 | 215602 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 166 | : | Tree | Private 2 | 4 | Width 0ft | 5991204.30373 | 2091328.48837 | 37.7218840999401 | -122.472507642021 | (37.7218840999401, -122.472507642021) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
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 | |||
174305 | 137082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008777.37552 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | 5 | 1 | 10 | 308 | 21 | |||
173609 | 19078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 215 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 5994825.04396 | 2087387.37086 | 37.7112716339463 | -122.459706433929 | (37.7112716339463, -122.459706433929) | 9 | 8 | 6 | 28861 | 24 | |||
173034 | 1248 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5993002.94201 | 2087547.889 | 37.7116074287673 | -122.466015680425 | (37.7116074287673, -122.466015680425) | 9 | 8 | 4 | 64 | 24 | |||
172849 | 185728 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984906.201 | 2100307.5936 | 37.7461717779802 | -122.494939985658 | (37.7461717779802, -122.494939985658) | 1 | 8 | 3 | 29491 | 35 | |||
172121 | 97504 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
171565 | 215603 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 168 | : | Tree | Private 2 | 16 | Width 0ft | 5991175.95809 | 2091313.63329 | 37.7218416708418 | -122.472604542184 | (37.7218416708418, -122.472604542184) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
170304 | 182454 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 5986553.619 | 2104615.5531 | 37.7580965659316 | -122.489560229786 | (37.7580965659316, -122.489560229786) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
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 | |||
168595 | 10717 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 | |||
167355 | 215581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991373.01779 | 2092318.20321 | 37.7246113758903 | -122.471996546509 | (37.7246113758903, -122.471996546509) | 9 | 8 | 4 | 59 | 40 | |||
166529 | 11718 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
166456 | 175374 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5991412.70367 | 2088734.17301 | 37.7147728061926 | -122.471598306927 | (37.7147728061926, -122.471598306927) | 9 | 8 | 6 | 64 | 24 | |||
165571 | 182456 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 0ft | 5986548.9803 | 2104699.0505 | 37.7583255560621 | -122.489582412162 | (37.7583255560621, -122.489582412162) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
165369 | 19093 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 257 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994426.29409 | 2087392.81881 | 37.7112636542582 | -122.461084998394 | (37.7112636542582, -122.461084998394) | 9 | 8 | 6 | 28861 | 24 | |||
165263 | 19071 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994967.06362 | 2087386.65714 | 37.7112778401642 | -122.459215529972 | (37.7112778401642, -122.459215529972) | 9 | 8 | 6 | 28861 | 24 | |||
164981 | 11712 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
162496 | 142237 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004726.9033 | 2110859.9695 | 37.7762864537737 | -122.427153959111 | (37.7762864537737, -122.427153959111) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
161460 | 137077 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2955 Steiner St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6001974.03932 | 2118352.39854 | 37.796702688621 | -122.437213445266 | (37.796702688621, -122.437213445266) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
160951 | 93024 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
160279 | 142976 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009963.6556 | 2120937.6931 | 37.8042521996842 | -122.409750018417 | (37.8042521996842, -122.409750018417) | 3 | 1 | 10 | 308 | 23 | |||
159991 | 11737 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
158218 | 227 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2X3 | 5990630.67566 | 2095430.16477 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | 1 | 8 | 4 | 64 | 40 | |||
157419 | 85427 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
155029 | 180579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | 10 | 3 | 8 | 309 | 1 | |||
154974 | 215632 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 75 | : | Tree | Private 2 | 7 | Width 0ft | 5991152.25672 | 2090589.68226 | 37.7198525080596 | -122.472633714394 | (37.7198525080596, -122.472633714394) | 9 | 8 | 4 | 64 | 40 | |||
154944 | 199847 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014254.2532 | 2092550.5249 | 37.7265467847844 | -122.392914674805 | (37.7265467847844, -122.392914674805) | 10 | 3 | 8 | 58 | 1 | |||
154835 | 137076 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 4 | : | Tree | Private 2 | 19 | Width 4ft | 6004731.62731 | 2110853.90859 | 37.7762700791404 | -122.427137185641 | (37.7762700791404, -122.427137185641) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
153823 | 199846 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.7266229511494 | -122.393068277245 | (37.7266229511494, -122.393068277245) | 10 | 3 | 8 | 58 | 1 | |||
153753 | 215601 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 155 | : | Tree | Private 2 | 15 | Width 0ft | 5991211.33426 | 2091424.54649 | 37.7221482587196 | -122.472490339055 | (37.7221482587196, -122.472490339055) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
152689 | 215628 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 71 | : | Tree | Private 2 | 11 | Width 0ft | 5991139.39343 | 2090599.41814 | 37.7198784957874 | -122.472678887333 | (37.7198784957874, -122.472678887333) | 9 | 8 | 4 | 64 | 40 | |||
152604 | 19063 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 175 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995252.88797 | 2087382.67456 | 37.7112833332178 | -122.458227367525 | (37.7112833332178, -122.458227367525) | 9 | 8 | 6 | 28861 | 24 | |||
152584 | 215599 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 52 | : | Tree | Private 2 | 14 | Width 0ft | 5991273.40065 | 2092440.71249 | 37.7249419909714 | -122.47234983349 | (37.7249419909714, -122.47234983349) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
151976 | 11615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
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 | |||
150849 | 215589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 551 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991458.35334 | 2093660.05844 | 37.7283007142025 | -122.47179930269 | (37.7283007142025, -122.47179930269) | 9 | 8 | 4 | 59 | 40 | |||
150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
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 | ||||
149879 | 5927 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
148629 | 11741 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 |
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) );