Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16288 | 16288 | 28500 | DPW Maintained 3 | Carpinus betulus :: European Hornbeam 296 | 270 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6010858.04605 | 2111602.35548 | 37.778669681710205 | -122.405996847495 | (37.7786696817102, -122.405996847495) | |||
28715 | 28715 | 188370 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 412 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013195.070169999 | 2105113.9405 | 37.760984378759495 | -122.397456959072 | (37.7609843787595, -122.397456959072) | |||
31898 | 31898 | 41357 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 145 Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | 7 | Permit Number 42007 | 6003035.73339 | 2119763.23013 | 37.8006367603272 | -122.433640627612 | (37.8006367603272, -122.433640627612) | ||
33520 | 33520 | 188383 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012774.398680001 | 2107410.7096700002 | 37.7672673654354 | -122.39907310465 | (37.7672673654354, -122.39907310465) | |||
33794 | 33794 | 188379 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012856.33782 | 2107488.21259 | 37.76748473695471 | -122.398795126902 | (37.7674847369547, -122.398795126902) | |||
34097 | 34097 | 125916 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006803.69739 | 2117989.96064 | 37.7959808828736 | -122.42047596031401 | (37.7959808828736, -122.420475960314) | |||
36415 | 36415 | 188368 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 236 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013709.670940001 | 2105953.26455 | 37.7633176176352 | -122.39573597772801 | (37.7633176176352, -122.395735977728) | |||
37125 | 37125 | 125925 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012221.71463 | 2118760.19231 | 37.7983995906195 | -122.401782627968 | (37.7983995906195, -122.401782627968) | |||
40428 | 40428 | 101798 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 600X Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x6 | 6012357.6476 | 2105099.7264400003 | 37.760898687745794 | -122.400352258064 | (37.7608986877458, -122.400352258064) | |||
43649 | 43649 | 125926 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012239.55484 | 2118762.42869 | 37.798406726745704 | -122.40172105228599 | (37.7984067267457, -122.401721052286) | |||
45433 | 45433 | 188382 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012796.792640001 | 2107431.55801 | 37.7673258582224 | -122.39899711012801 | (37.7673258582224, -122.398997110128) | |||
45887 | 45887 | 125929 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012293.810740001 | 2118770.30436 | 37.798431378969 | -122.401533862924 | (37.798431378969, -122.401533862924) | |||
48278 | 48278 | 125910 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006696.335 | 2117986.05162 | 37.7959640988078 | -122.42084717796301 | (37.7959640988078, -122.420847177963) | |||
48840 | 48840 | 125931 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012329.26329 | 2118775.25448 | 37.7984469489314 | -122.401411533519 | (37.7984469489314, -122.401411533519) | |||
50922 | 50922 | 89304 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 536 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51908 | 6010977.9189 | 2118648.9247 | 37.7980245876995 | -122.406078720701 | (37.7980245876995, -122.406078720701) | |
52742 | 52742 | 188373 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 475 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6013797.63065 | 2111569.97668 | 37.7787447472234 | -122.39582534336999 | (37.7787447472234, -122.39582534337) | |||
54857 | 54857 | 188388 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012674.11663 | 2107312.56439 | 37.7669922916006 | -122.39941307715799 | (37.7669922916006, -122.399413077158) | |||
56378 | 56378 | 125913 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006753.61977 | 2117988.9997 | 37.795975422175495 | -122.42064917063801 | (37.7959754221755, -122.420649170638) | |||
59280 | 59280 | 142942 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 530 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6011035.2352 | 2118656.8924 | 37.79804967068829 | -122.40588095031099 | (37.7980496706883, -122.405880950311) | |||
59546 | 59546 | 188371 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 227 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6013205.05645 | 2105990.1655099997 | 37.7633908557151 | -122.397483873981 | (37.7633908557151, -122.397483873981) | |||
59841 | 59841 | 125923 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 248 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012266.9612300005 | 2118833.17133 | 37.7986024983571 | -122.401631192034 | (37.7986024983571, -122.401631192034) | |||
60754 | 60754 | 188387 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012693.86322 | 2107331.16353 | 37.7670444612605 | -122.399346082175 | (37.7670444612605, -122.399346082175) | |||
61595 | 61595 | 125908 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006659.65002 | 2117982.23073 | 37.7959515397918 | -122.42097384386801 | (37.7959515397918, -122.420973843868) | |||
61675 | 61675 | 104172 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 1266 Washington St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008673.1204 | 2117324.35161 | 37.7942584563068 | -122.413960264165 | (37.7942584563068, -122.413960264165) | ||
62509 | 62509 | 188372 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 475 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6013770.62402 | 2111547.1742700003 | 37.7786806345488 | -122.395917172236 | (37.7786806345488, -122.395917172236) | |||
68128 | 68128 | 72037 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 534 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1988 12:00:00 AM | 3 | 6010993.0833 | 2118650.7238 | 37.7980303757469 | -122.40602637404498 | (37.7980303757469, -122.406026374045) | ||
69896 | 69896 | 188374 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 475 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013821.87003 | 2111598.12216 | 37.7788233767445 | -122.39574346190001 | (37.7788233767445, -122.3957434619) | |||
71177 | 71177 | 204698 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1945 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993754.14919 | 2102286.0880299998 | 37.7521182001029 | -122.464488765067 | (37.7521182001029, -122.464488765067) | |||
73038 | 73038 | 125924 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012205.28794 | 2118757.45492 | 37.798391157692706 | -122.401839277161 | (37.7983911576927, -122.401839277161) | |||
73342 | 73342 | 188376 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 475 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6013901.71511 | 2111674.04237 | 37.7790362777336 | -122.395472564503 | (37.7790362777336, -122.395472564503) | |||
74624 | 74624 | 188367 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 212 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013704.70501 | 2106043.59868 | 37.76356537905421 | -122.39575948333 | (37.7635653790542, -122.39575948333) | |||
76832 | 76832 | 142941 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 506 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6011048.3435 | 2118659.4626 | 37.7980574609154 | -122.405835772705 | (37.7980574609154, -122.405835772705) | |||
84670 | 84670 | 122829 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
89394 | 89394 | 122835 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
95017 | 95017 | 122832 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
100199 | 100199 | 122830 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
101962 | 101962 | 122827 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
109686 | 109686 | 122831 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
117508 | 117508 | 122828 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
137833 | 137833 | 188386 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012716.239519999 | 2107351.14847 | 37.767100582538205 | -122.399270088563 | (37.7671005825382, -122.399270088563) | |||
142477 | 142477 | 122833 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
143292 | 143292 | 188380 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012838.02479 | 2107469.00844 | 37.767430986267705 | -122.398857121681 | (37.7674309862677, -122.398857121681) | |||
144603 | 144603 | 122834 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 201x Broadway | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 6012272.0 | 2118721.0 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | ||||
146714 | 146714 | 125920 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1376 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006349.33021 | 2119047.1504 | 37.7988580434315 | -122.422123304265 | (37.7988580434315, -122.422123304265) | |||
146802 | 146802 | 125915 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006787.55943 | 2117990.13988 | 37.795980465571105 | -122.420531813612 | (37.7959804655711, -122.420531813612) | |||
148105 | 148105 | 188390 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 248 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010733.16033 | 2111734.1060900004 | 37.779024452547 | -122.406438163709 | (37.779024452547, -122.406438163709) | |||
148732 | 148732 | 125922 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 248 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012285.01589 | 2118835.9366 | 37.798611098574796 | -122.401568911293 | (37.7986110985748, -122.401568911293) | |||
149288 | 149288 | 188381 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012815.66036 | 2107449.5989599996 | 37.7673764460054 | -122.39893311528 | (37.7673764460054, -122.39893311528) | |||
150779 | 150779 | 188384 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012754.127669999 | 2107390.09436 | 37.7672096307557 | -122.399141772392 | (37.7672096307557, -122.399141772392) | |||
151027 | 151027 | 104174 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 1266 Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008660.71895 | 2117323.02559 | 37.7942541188741 | -122.414003080877 | (37.7942541188741, -122.414003080877) | ||
151705 | 151705 | 125914 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006770.3381 | 2117989.0482799998 | 37.7959764977783 | -122.420591325329 | (37.7959764977783, -122.420591325329) | |||
154323 | 154323 | 204697 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1935 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993752.62389 | 2102311.14457 | 37.752186911019 | -122.464495858899 | (37.752186911019, -122.464495858899) | |||
156371 | 156371 | 188378 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012877.85295 | 2107508.5027099997 | 37.767541647848 | -122.398722132537 | (37.767541647848, -122.398722132537) | |||
161468 | 161468 | 125921 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 248 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012303.22418 | 2118837.65459 | 37.798616831752796 | -122.401506025282 | (37.7986168317528, -122.401506025282) | |||
165089 | 165089 | 188385 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012733.668430001 | 2107369.50646 | 37.7671519608071 | -122.39921109301399 | (37.7671519608071, -122.399211093014) | |||
168264 | 168264 | 125912 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006736.44851 | 2117987.48621 | 37.7959702987412 | -122.420708479127 | (37.7959702987412, -122.420708479127) | |||
172248 | 172248 | 188377 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 475 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013936.90466 | 2111707.693 | 37.779130631918704 | -122.39535318671601 | (37.7791306319187, -122.395353186716) | |||
172960 | 172960 | 125918 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1376 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006386.86184 | 2119052.59014 | 37.7988750963777 | -122.421993818967 | (37.7988750963777, -122.421993818967) | |||
173784 | 173784 | 188389 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 190 Irwin St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012654.913240001 | 2107292.22717 | 37.766935379800294 | -122.39947807115499 | (37.7669353798003, -122.399478071155) | |||
173971 | 173971 | 125909 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006677.52314 | 2117984.18012 | 37.79595789979321 | -122.4209121378 | (37.7959578997932, -122.4209121378) | |||
176341 | 176341 | 125911 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006720.82388 | 2117986.3621900002 | 37.7959663318359 | -122.420762463624 | (37.7959663318359, -122.420762463624) | |||
176465 | 176465 | 125930 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012311.41375 | 2118772.5456 | 37.7984385150748 | -122.401473108324 | (37.7984385150748, -122.401473108324) | |||
177199 | 177199 | 188366 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 211 Texas St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6013759.09778 | 2106092.2899700003 | 37.763702100305 | -122.395574766173 | (37.763702100305, -122.395574766173) | |||
178365 | 178365 | 188392 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1172 Key Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6012412.13674 | 2090491.60305 | 37.7207909101503 | -122.39913838194299 | (37.7207909101503, -122.399138381943) | ||||
178564 | 178564 | 39585 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 860 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2015 12:00:00 AM | 1 | Permit Number 40996 | 6011833.87 | 2104371.56164 | 37.7588700869985 | -122.40211259103901 | (37.7588700869985, -122.402112591039) | |
180101 | 180101 | 125927 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012257.172259999 | 2118765.37838 | 37.7984158089854 | -122.401660297682 | (37.7984158089854, -122.401660297682) | |||
180347 | 180347 | 188375 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 475 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6013870.81551 | 2111644.71049 | 37.7789540203558 | -122.395577403888 | (37.7789540203558, -122.395577403888) | |||
180645 | 180645 | 125928 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 251 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012276.19333 | 2118767.35464 | 37.7984222967127 | -122.40159461751999 | (37.7984222967127, -122.40159461752) | |||
183228 | 183228 | 104173 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 1266 Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008666.764169999 | 2117323.84982 | 37.7942567215292 | -122.41398222199899 | (37.7942567215292, -122.413982221999) | ||
185680 | 185680 | 125919 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1376 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006369.25772 | 2119050.19129 | 37.798867516882 | -122.422054564589 | (37.798867516882, -122.422054564589) | |||
186235 | 186235 | 125917 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006819.23263 | 2117991.32629 | 37.795985508065904 | -122.42042230225799 | (37.7959855080659, -122.420422302258) | |||
187167 | 187167 | 188369 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 467 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013826.93076 | 2104919.88069 | 37.76048669391479 | -122.39525801864599 | (37.7604866939148, -122.395258018646) | |||
187852 | 187852 | 125907 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 1401 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006644.7585 | 2117981.33145 | 37.7959482311701 | -122.421025307596 | (37.7959482311701, -122.421025307596) | |||
188302 | 188302 | 188391 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 615 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6009680.8732900005 | 2111478.3072200003 | 37.778263165651104 | -122.410060400886 | (37.7782631656511, -122.410060400886) |
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");