Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41744 | 41744 | 248172 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6007302.01446 | 2098729.32454 | 37.74312379432521 | -122.41738604353701 | (37.7431237943252, -122.417386043537) | ||||
56013 | 56013 | 248173 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007303.951309999 | 2098726.55555 | 37.743116300271 | -122.41737915022101 | (37.743116300271, -122.417379150221) | ||||
97405 | 97405 | 85294 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2255 Mariposa St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752.0 | 2105977.0 | 37.7632178155038 | -122.40596731591499 | (37.7632178155038, -122.405967315915) | |||
33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
74522 | 74522 | 249896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 32 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | |||
185525 | 185525 | 249893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 29 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 0ft | 6011394.800530001 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | |||
91724 | 91724 | 103067 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 255 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | 6x6 | Permit Number 769997 | 6012256.1 | 2118721.6 | 37.7982955442476 | -122.401660929382 | (37.7982955442476, -122.401660929382) | |
24124 | 24124 | 234881 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.40624413046899 | (37.749070568567, -122.406244130469) | ||||
28429 | 28429 | 234882 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6010551.469930001 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | ||||
32073 | 32073 | 234877 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | ||||
38753 | 38753 | 234884 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6010535.25533 | 2100821.90556 | 37.749050949857796 | -122.406353718268 | (37.7490509498578, -122.406353718268) | ||||
41709 | 41709 | 234885 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010529.65259 | 2100820.82881 | 37.7490476799194 | -122.406373016826 | (37.7490476799194, -122.406373016826) | ||||
51715 | 51715 | 234880 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.40620829069799 | (37.7490776534227, -122.406208290698) | ||||
55335 | 55335 | 234886 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6010522.647340001 | 2100819.38367 | 37.7490433200014 | -122.40639713934401 | (37.7490433200014, -122.406397139344) | ||||
59758 | 59758 | 234871 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6010740.989580001 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | ||||
133456 | 133456 | 234878 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6010615.53478 | 2100839.3237900003 | 37.749103267009204 | -122.406077336824 | (37.7491032670092, -122.406077336824) | ||||
147141 | 147141 | 234872 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | ||||
169608 | 169608 | 234873 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6010726.23893 | 2100862.83367 | 37.7491740112676 | -122.40569617445699 | (37.7491740112676, -122.405696174457) | ||||
172182 | 172182 | 234883 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6010542.260840001 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | ||||
178954 | 178954 | 234875 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | ||||
180682 | 180682 | 234876 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6010649.76891 | 2100846.09542 | 37.749123775143204 | -122.405959431208 | (37.7491237751432, -122.405959431208) | ||||
182816 | 182816 | 234879 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6010587.102659999 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | ||||
185485 | 185485 | 234874 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356001 | (37.7491536092595, -122.40577509356) | ||||
46578 | 46578 | 234892 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | ||||
50221 | 50221 | 234891 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010619.31212 | 2100642.55964 | 37.748563207025704 | -122.406050414705 | (37.7485632070257, -122.406050414705) | ||||
72921 | 72921 | 234889 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | ||||
146490 | 146490 | 234888 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6010611.762999999 | 2100694.95228 | 37.7487066435094 | -122.40608021012699 | (37.7487066435094, -122.406080210127) | ||||
146994 | 146994 | 234890 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.40603639336099 | (37.7486290355994, -122.406036393361) | ||||
149461 | 149461 | 234894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | ||||
168626 | 168626 | 234893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | ||||
170865 | 170865 | 234887 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6010600.221609999 | 2100713.10517 | 37.7487558418292 | -122.40612139908501 | (37.7487558418292, -122.406121399085) | ||||
28694 | 28694 | 246559 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.42360165389299 | (37.7722588698898, -122.423601653893) | |||
28854 | 28854 | 246564 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | |||
30102 | 30102 | 246567 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | |||
32751 | 32751 | 246565 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.772520866678796 | -122.423667646169 | (37.7725208666788, -122.423667646169) | |||
36823 | 36823 | 246562 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | |||
58148 | 58148 | 246560 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | |||
62755 | 62755 | 246558 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.772239401347605 | -122.423593061791 | (37.7722394013476, -122.423593061791) | |||
66652 | 66652 | 246571 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | |||
69195 | 69195 | 246561 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.42361988494801 | (37.7722999149342, -122.423619884948) | |||
130105 | 130105 | 246569 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005694.6084199995 | 2109539.50826 | 37.772715462883 | -122.42371248725401 | (37.772715462883, -122.423712487254) | |||
152965 | 152965 | 246568 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6005695.27816 | 2109533.51475 | 37.7726990439551 | -122.423709744321 | (37.7726990439551, -122.423709744321) | |||
159619 | 159619 | 246563 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 7ft | 6005707.64026 | 2109451.4652299997 | 37.7724744535597 | -122.42366114764499 | (37.7724744535597, -122.423661147645) | |||
164121 | 164121 | 246566 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005705.41603 | 2109475.54193 | 37.772540436826 | -122.42367055365101 | (37.772540436826, -122.423670553651) | |||
171792 | 171792 | 246570 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005693.82305 | 2109545.39115 | 37.7727315715478 | -122.423715622299 | (37.7727315715478, -122.423715622299) | |||
178229 | 178229 | 246557 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005728.07536 | 2109359.1735900003 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | |||
176864 | 176864 | 135666 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 9ft | 6000472.49775 | 2118651.8946700003 | 37.797439556256705 | -122.442430617479 | (37.7974395562567, -122.442430617479) | |||
123249 | 123249 | 24282 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300X Winding Way | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
89334 | 89334 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
92450 | 92450 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
114742 | 114742 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
118020 | 118020 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
119705 | 119705 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
144536 | 144536 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
177775 | 177775 | 53540 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.440219999 | 2113376.70713 | 37.782622110333904 | -122.462172779062 | (37.7826221103339, -122.462172779062) | ||
49096 | 49096 | 212850 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 3ft | 5999489.821880001 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | |||
909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
29497 | 29497 | 135665 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5996326.409519999 | 2114621.95963 | 37.7861372526689 | -122.45648551290199 | (37.7861372526689, -122.456485512902) | |||
134366 | 134366 | 135663 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5996346.46825 | 2114626.15487 | 37.78614992323771 | -122.456416418905 | (37.7861499232377, -122.456416418905) | |||
161540 | 161540 | 135664 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5996336.60886 | 2114624.27331 | 37.786144190959504 | -122.45645039347099 | (37.7861441909595, -122.456450393471) | |||
23464 | 23464 | 121867 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 382 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990303.78145 | 2112825.7530799997 | 37.7808577673116 | -122.477190674715 | (37.7808577673116, -122.477190674715) | |||
25205 | 25205 | 195981 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6018524.13374 | 2099557.3325900002 | 37.746022348857295 | -122.37864001312799 | (37.7460223488573, -122.378640013128) | ||||
26910 | 26910 | 195984 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018485.16554 | 2099556.70792 | 37.7460184853642 | -122.378774718093 | (37.7460184853642, -122.378774718093) | ||||
29206 | 29206 | 195983 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | ||||
46984 | 46984 | 195986 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018468.61509 | 2099561.7634900003 | 37.7460314544851 | -122.378832298987 | (37.7460314544851, -122.378832298987) | ||||
61850 | 61850 | 195989 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018358.23149 | 2099573.02507 | 37.7460562901585 | -122.37921477706699 | (37.7460562901585, -122.379214777067) | ||||
69871 | 69871 | 195990 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018348.89198 | 2099575.3229 | 37.746062084515295 | -122.379247231793 | (37.7460620845153, -122.379247231793) | ||||
120047 | 120047 | 195988 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018362.603680001 | 2099564.59582 | 37.7460333862374 | -122.379199073078 | (37.7460333862374, -122.379199073078) | ||||
130066 | 130066 | 195985 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018474.359130001 | 2099556.32192 | 37.74601682971289 | -122.378812058831 | (37.7460168297129, -122.378812058831) | ||||
130871 | 130871 | 195987 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | ||||
149276 | 149276 | 195992 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018320.61791 | 2099573.80473 | 37.7460563567193 | -122.379344895446 | (37.7460563567193, -122.379344895446) | ||||
177923 | 177923 | 195991 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018339.20952 | 2099575.6179 | 37.7460623605839 | -122.379280733321 | (37.7460623605839, -122.379280733321) | ||||
187127 | 187127 | 195982 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6018502.102580001 | 2099556.87815 | 37.746019886521296 | -122.378716163238 | (37.7460198865213, -122.378716163238) | ||||
30532 | 30532 | 119696 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
79566 | 79566 | 119689 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
85011 | 85011 | 119690 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
86483 | 86483 | 119684 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
87621 | 87621 | 119685 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
87630 | 87630 | 119692 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
88222 | 88222 | 119683 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
96316 | 96316 | 119697 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
100653 | 100653 | 119693 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
103536 | 103536 | 119694 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
118707 | 118707 | 119686 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
120932 | 120932 | 119687 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
124714 | 124714 | 119691 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
139912 | 139912 | 119688 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
142339 | 142339 | 119695 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
85674 | 85674 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
140337 | 140337 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
47717 | 47717 | 234909 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6009677.77783 | 2096362.7223200002 | 37.73675900081071 | -122.409004306302 | (37.7367590008107, -122.409004306302) | |||
52696 | 52696 | 234902 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009698.6344099995 | 2096418.94153 | 37.7369145349811 | -122.40893616107799 | (37.7369145349811, -122.408936161078) | ||||
68610 | 68610 | 234900 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6009696.65795 | 2096435.2295400002 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | ||||
72864 | 72864 | 234906 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6009686.024230001 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | |||
73733 | 73733 | 234901 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009690.97834 | 2096436.6273599998 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | ||||
156252 | 156252 | 234905 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6009688.58582 | 2096390.10165 | 37.736834783993004 | -122.40896886942 | (37.736834783993, -122.40896886942) | |||
172242 | 172242 | 234908 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6009679.550530001 | 2096368.23252 | 37.73677422993671 | -122.408998565949 | (37.7367742299367, -122.408998565949) | |||
173066 | 173066 | 234898 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6009700.61042 | 2096445.6891 | 37.736988088737704 | -122.40893121572901 | (37.7369880887377, -122.408931215729) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");