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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173877 | 173877 | 195973 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015335.01264 | 2100318.2949099997 | 37.747935470342895 | -122.38972080559601 | (37.7479354703429, -122.389720805596) | |||
23421 | 23421 | 195972 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015355.8319 | 2100319.8042599997 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | |||
171288 | 171288 | 195971 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015377.86647 | 2100320.4119700002 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | |||
33236 | 33236 | 195970 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015399.1088 | 2100325.42161 | 37.747958592828205 | -122.389499659601 | (37.7479585928282, -122.389499659601) | ||||
26205 | 26205 | 195969 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015417.97335 | 2100326.09336 | 37.7479614832509 | -122.389434473133 | (37.7479614832509, -122.389434473133) | ||||
38396 | 38396 | 195968 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6015437.03514 | 2100327.8138099997 | 37.747967264084295 | -122.389368677829 | (37.7479672640843, -122.389368677829) | ||||
33201 | 33201 | 195967 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6015456.783980001 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | ||||
38334 | 38334 | 195966 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | ||||
137968 | 137968 | 195965 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015497.16873 | 2100330.63483 | 37.747978343742794 | -122.389160933554 | (37.7479783437428, -122.389160933554) | ||||
65985 | 65985 | 195964 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015516.57214 | 2100331.8217700003 | 37.7479826784534 | -122.38909391965001 | (37.7479826784534, -122.38909391965) | ||||
74090 | 74090 | 195963 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015537.22246 | 2100333.68578 | 37.7479889413373 | -122.389022641203 | (37.7479889413373, -122.389022641203) | ||||
62177 | 62177 | 195962 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6015556.6084199995 | 2100333.99599 | 37.7479908676843 | -122.388955626422 | (37.7479908676843, -122.388955626422) | ||||
175233 | 175233 | 195961 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | ||||
46092 | 46092 | 195960 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015597.7328 | 2100337.72732 | 37.748003392560896 | -122.38881367921302 | (37.7480033925609, -122.388813679213) | ||||
179584 | 179584 | 195959 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | ||||
60765 | 60765 | 195957 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.38857303683399 | (37.7480149542209, -122.388573036834) | ||||
31601 | 31601 | 195958 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015649.240619999 | 2100340.8983400003 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | ||||
74084 | 74084 | 195956 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6015682.424790001 | 2100340.57249 | 37.748015898531605 | -122.388521013727 | (37.7480158985316, -122.388521013727) | ||||
158786 | 158786 | 195955 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.38845740468399 | (37.7480218628289, -122.388457404684) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
188309 | 188309 | 234896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 10ft | 6007240.7393 | 2101963.9408299997 | 37.7520018736867 | -122.41782715109501 | (37.7520018736867, -122.417827151095) | |||
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) | |||
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) | |||
3855 | 3855 | 248614 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | |||
180467 | 180467 | 246918 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 5997638.105140001 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | |||
3856 | 3856 | 246917 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5997637.485090001 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | |||
495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
173216 | 173216 | 196023 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1670 Owen St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6013858.29957 | 2107482.27299 | 37.7675242045935 | -122.395329033601 | (37.7675242045935, -122.395329033601) | |||
160001 | 160001 | 196024 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1670 Owen St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6013848.21751 | 2107498.5657599997 | 37.7675683801977 | -122.39536504787701 | (37.7675683801977, -122.395365047877) | |||
180656 | 180656 | 247225 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6002109.5730099995 | 2108309.81574 | 37.7691360073432 | -122.43602549030001 | (37.7691360073432, -122.4360254903) | ||||
4763 | 4763 | 220524 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.770296793780396 | -122.431683217203 | (37.7702967937804, -122.431683217203) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
176308 | 176308 | 244427 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6005661.3527 | 2109672.0384 | 37.7730774813758 | -122.423836948028 | (37.7730774813758, -122.423836948028) | |||
147500 | 147500 | 244428 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005659.9824 | 2109685.0561 | 37.7731131474821 | -122.423842613892 | (37.7731131474821, -122.423842613892) | |||
37654 | 37654 | 244429 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005659.2973 | 2109696.7034 | 37.773145089481794 | -122.4238458121 | (37.7731450894818, -122.4238458121) | |||
46046 | 46046 | 244430 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.42385118560499 | (37.7731694680478, -122.423851185605) | |||
66890 | 66890 | 244431 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.77320137163979 | -122.42385675402599 | (37.7732013716398, -122.423856754026) | |||
155716 | 155716 | 244432 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6005649.0202 | 2109761.1065 | 37.7733213446724 | -122.423885942412 | (37.7733213446724, -122.423885942412) | |||
150135 | 150135 | 244433 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.42389175449499 | (37.7733626541324, -122.423891754495) | |||
153505 | 153505 | 244434 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6005644.2243 | 2109791.2526 | 37.7734038478353 | -122.42390467617399 | (37.7734038478353, -122.423904676174) | |||
168209 | 168209 | 244332 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005642.1688 | 2109804.2702 | 37.773439474978794 | -122.42391271229602 | (37.7734394749788, -122.423912712296) | |||
185211 | 185211 | 244333 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005640.1134 | 2109813.1769999997 | 37.773463814863 | -122.42392045570699 | (37.773463814863, -122.423920455707) | |||
152207 | 152207 | 244334 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005631.2066 | 2109866.6178 | 37.77361004755279 | -122.423955066597 | (37.7736100475528, -122.423955066597) | |||
59788 | 59788 | 244335 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | |||
47891 | 47891 | 244336 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | |||
136569 | 136569 | 244337 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005627.7809 | 2109896.0788 | 37.7736907469384 | -122.423969012041 | (37.7736907469384, -122.423969012041) | |||
168334 | 168334 | 244338 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6005626.4106 | 2109908.4113 | 37.773724531640894 | -122.42397462928001 | (37.7737245316409, -122.42397462928) | |||
73006 | 73006 | 244339 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6005625.7255 | 2109918.6883 | 37.7737527111209 | -122.42397773010799 | (37.7737527111209, -122.423977730108) | |||
157480 | 157480 | 244260 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005614.2528 | 2110021.9252 | 37.774035526971396 | -122.42402475899401 | (37.7740355269714, -122.424024758994) | |||
90928 | 90928 | 244261 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005613.489 | 2110034.9096 | 37.7740711358709 | -122.424028324662 | (37.7740711358709, -122.424028324662) | |||
157234 | 157234 | 244262 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.7252 | 2110055.5318 | 37.7741277163216 | -122.424032433594 | (37.7741277163216, -122.424032433594) | |||
46340 | 46340 | 244263 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005610.4338 | 2110073.0988 | 37.7741758216851 | -122.424041609468 | (37.7741758216851, -122.424041609468) | |||
136078 | 136078 | 244264 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005607.3787 | 2110087.6108 | 37.7742154956389 | -122.42405320983299 | (37.7742154956389, -122.424053209833) | |||
116487 | 116487 | 244265 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005602.0322 | 2110112.8157 | 37.7742844003359 | -122.42407349716999 | (37.7742844003359, -122.42407349717) | |||
65982 | 65982 | 244266 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005600.5046 | 2110125.0362 | 37.7743178686238 | -122.42407965066499 | (37.7743178686238, -122.424079650665) | |||
147941 | 147941 | 244402 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005599.7408 | 2110138.7844 | 37.774355574729796 | -122.424083270702 | (37.7743555747298, -122.424083270702) | |||
64205 | 64205 | 244403 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005596.6857 | 2110150.2412 | 37.7743868598384 | -122.424094653801 | (37.7743868598384, -122.424094653801) | |||
76412 | 76412 | 244404 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005594.3943 | 2110164.7531 | 37.7744265766299 | -122.424103612435 | (37.7744265766299, -122.424103612435) | |||
161802 | 161802 | 244405 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6005589.0478 | 2110200.651 | 37.774524841704704 | -122.42412466048701 | (37.7745248417047, -122.424124660487) | |||
129623 | 129623 | 244406 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005586.7565 | 2110217.4543 | 37.7745708501281 | -122.42413378179899 | (37.7745708501281, -122.424133781799) | |||
53575 | 53575 | 244407 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | |||
153011 | 153011 | 244408 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6005581.41 | 2110245.7143 | 37.7746481433715 | -122.42415428662599 | (37.7746481433715, -122.424154286626) | |||
186484 | 186484 | 244409 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6005580.6462 | 2110260.99 | 37.7746900436181 | -122.424158015373 | (37.7746900436181, -122.424158015373) |
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");