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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64050 | 64050 | 139028 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000547.3036 | 2114093.8303 | 37.7849285655089 | -122.44184446112301 | (37.7849285655089, -122.441844461123) | |||
1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
36994 | 36994 | 139027 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000525.7297 | 2114092.4384 | 37.784923514385 | -122.441918999732 | (37.784923514385, -122.441918999732) | |||
49578 | 49578 | 139026 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000502.7639999995 | 2114090.3506 | 37.784916473139894 | -122.44199830353001 | (37.7849164731399, -122.44199830353) | |||
7654 | 7654 | 139157 | Undocumented 2 | :: 54 | 1699 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6003069.5459 | 2114034.3612 | 37.7849086753549 | -122.433114070807 | (37.7849086753549, -122.433114070807) | ||||
132579 | 132579 | 139025 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000486.0616 | 2114086.871 | 37.7849059672476 | -122.442055838439 | (37.7849059672476, -122.442055838439) | |||
168796 | 168796 | 139024 | Undocumented 2 | :: 54 | 2511 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000470.0552 | 2114083.3913 | 37.78489550071689 | -122.442110965396 | (37.7848955007169, -122.442110965396) | |||
52327 | 52327 | 139022 | Undocumented 2 | :: 54 | 2557 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000419.2522 | 2114077.8239 | 37.784877318741 | -122.44228632704201 | (37.784877318741, -122.442286327042) | |||
156101 | 156101 | 139019 | Undocumented 2 | :: 54 | 2557 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000372.6248 | 2114069.4727 | 37.7848517309131 | -122.442447042495 | (37.7848517309131, -122.442447042495) | |||
59014 | 59014 | 139029 | Undocumented 2 | :: 54 | 1535 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000616.8967 | 2114052.0744 | 37.784817879809204 | -122.441600694473 | (37.7848178798092, -122.441600694473) | |||
73809 | 73809 | 139018 | Undocumented 2 | :: 54 | 2569 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000314.1665 | 2114058.3378 | 37.784817825136706 | -122.44264848882601 | (37.7848178251367, -122.442648488826) | |||
72583 | 72583 | 114625 | Undocumented 2 | :: 54 | 2400X Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
80039 | 80039 | 114619 | Undocumented 2 | :: 54 | 2400X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
83119 | 83119 | 114623 | Undocumented 2 | :: 54 | 2400X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
83415 | 83415 | 114615 | Undocumented 2 | :: 54 | 2400X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
83855 | 83855 | 114626 | Undocumented 2 | :: 54 | 2400X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
87576 | 87576 | 114627 | Undocumented 2 | :: 54 | 2400X Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
89960 | 89960 | 114628 | Undocumented 2 | :: 54 | 2400X Post St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
96844 | 96844 | 114629 | Undocumented 2 | :: 54 | 2400X Post St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
97624 | 97624 | 114622 | Undocumented 2 | :: 54 | 2400X Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
99135 | 99135 | 114630 | Undocumented 2 | :: 54 | 2400X Post St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
109941 | 109941 | 114620 | Undocumented 2 | :: 54 | 2400X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
115565 | 115565 | 114618 | Undocumented 2 | :: 54 | 2400X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
120303 | 120303 | 114621 | Undocumented 2 | :: 54 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
54538 | 54538 | 139014 | Undocumented 2 | :: 54 | 2569 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000244.5734 | 2114049.2907 | 37.7847890167684 | -122.442888607586 | (37.7847890167684, -122.442888607586) | |||
38604 | 38604 | 139030 | Undocumented 2 | :: 54 | 1535 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000620.3764 | 2114029.1087 | 37.784755020167395 | -122.441587007239 | (37.7847550201674, -122.441587007239) | |||
168900 | 168900 | 139031 | Undocumented 2 | :: 54 | 1535 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000623.856000001 | 2114017.2778 | 37.784722733809 | -122.441574119703 | (37.784722733809, -122.441574119703) | |||
180411 | 180411 | 139043 | Undocumented 2 | :: 54 | 1434 BAKER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000190.2907 | 2114006.1429 | 37.7846674491742 | -122.443073307519 | (37.7846674491742, -122.443073307519) | |||
161034 | 161034 | 140786 | Undocumented 2 | :: 54 | 72 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996552.5125 | 2114073.3864 | 37.784643994956 | -122.455663594493 | (37.784643994956, -122.455663594493) | |||
39868 | 39868 | 142767 | Undocumented 2 | :: 54 | 724 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6007520.0381 | 2113832.9802 | 37.7846071803113 | -122.41770248523599 | (37.7846071803113, -122.417702485236) | |||
46800 | 46800 | 141745 | Undocumented 2 | :: 54 | 1595 GEARY BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004047.2174 | 2113886.8031 | 37.7845589275233 | -122.429721115021 | (37.7845589275233, -122.429721115021) | |||
60875 | 60875 | 138281 | Undocumented 2 | :: 54 | 2181 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001824.7124 | 2113924.8454 | 37.784537281287896 | -122.437412940551 | (37.7845372812879, -122.437412940551) | |||
124115 | 124115 | 139041 | Undocumented 2 | :: 54 | 1434 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000198.6419 | 2113946.9888 | 37.7845055034656 | -122.443040165571 | (37.7845055034656, -122.443040165571) | |||
92851 | 92851 | 7876 | DPW Maintained 3 | :: 54 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.784504100894395 | -122.42291717866101 | (37.7845041008944, -122.422917178661) | ||
31070 | 31070 | 138278 | Undocumented 2 | :: 54 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.784492318138106 | -122.437714255164 | (37.7844923181381, -122.437714255164) | |||
156816 | 156816 | 139034 | Undocumented 2 | :: 54 | 1501 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000637.7747 | 2113931.6783 | 37.7844884926143 | -122.441519821021 | (37.7844884926143, -122.441519821021) | |||
137192 | 137192 | 140325 | Undocumented 2 | :: 54 | 1455 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004557.9993 | 2113847.3125 | 37.7844794061151 | -122.42795116719601 | (37.7844794061151, -122.427951167196) | |||
51353 | 51353 | 138277 | Undocumented 2 | :: 54 | 2181 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001707.4914 | 2113906.1178 | 37.784479195254995 | -122.437817142826 | (37.784479195255, -122.437817142826) | |||
183313 | 183313 | 139054 | Undocumented 2 | :: 54 | 1480 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999713.5777 | 2113947.3354 | 37.78447878674479 | -122.44471834133499 | (37.7844787867448, -122.444718341335) | |||
184028 | 184028 | 139040 | Undocumented 2 | :: 54 | 1434 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000201.4256 | 2113926.1108 | 37.7844483365891 | -122.44302903507099 | (37.7844483365891, -122.443029035071) | |||
5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
69387 | 69387 | 139039 | Undocumented 2 | :: 54 | 1501 BRODERICK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000650.9974 | 2113849.5584 | 37.7842637658196 | -122.441468180362 | (37.7842637658196, -122.441468180362) | |||
5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
172733 | 172733 | 140806 | Undocumented 2 | :: 54 | 530 EUCLID AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996678.7438 | 2113864.2417 | 37.7840769823676 | -122.45521175977501 | (37.7840769823676, -122.455211759775) | |||
72123 | 72123 | 139091 | Undocumented 2 | :: 54 | 1408 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999733.102000001 | 2113785.5627 | 37.7840357150055 | -122.44463916277901 | (37.7840357150055, -122.444639162779) | |||
39749 | 39749 | 139753 | Undocumented 2 | :: 54 | 1171 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005547.6328 | 2113641.325 | 37.7839697525349 | -122.424512713511 | (37.7839697525349, -122.424512713511) | |||
68182 | 68182 | 140334 | Undocumented 2 | :: 54 | 1561 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003122.307 | 2113686.3043 | 37.7839559916453 | -122.43290666022301 | (37.7839559916453, -122.432906660223) | |||
28319 | 28319 | 139084 | Undocumented 2 | :: 54 | 2512 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000122.7854 | 2113741.6890000002 | 37.7839374779531 | -122.443287851631 | (37.7839374779531, -122.443287851631) | |||
92536 | 92536 | 114785 | Permitted Site 1 | :: 54 | 2459 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 6000398.9 | 2113706.0 | 37.7838552262656 | -122.44233003645701 | (37.7838552262656, -122.442330036457) | ||||
5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
189029 | 189029 | 140863 | Undocumented 2 | :: 54 | 106 JORDAN AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996246.41 | 2113718.2127 | 37.7836512118011 | -122.45669690496901 | (37.7836512118011, -122.456696904969) | |||
149988 | 149988 | 141161 | Undocumented 2 | :: 54 | 2007 Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002005.8356 | 2113598.0542 | 37.7836502911761 | -122.43676291583598 | (37.7836502911761, -122.436762915836) | |||
48404 | 48404 | 141143 | Undocumented 2 | :: 54 | 2011 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001931.7546 | 2113588.2444 | 37.783619145517896 | -122.43701850487301 | (37.7836191455179, -122.437018504873) | |||
74672 | 74672 | 140885 | Undocumented 2 | :: 54 | 112 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996566.0494 | 2113683.1859999998 | 37.7835733852629 | -122.45558854835899 | (37.7835733852629, -122.455588548359) | |||
28402 | 28402 | 137551 | Undocumented 2 | :: 54 | 1526 Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002668.0924 | 2113464.7267 | 37.7833218226195 | -122.434462226416 | (37.7833218226195, -122.434462226416) | |||
36535 | 36535 | 139766 | Undocumented 2 | :: 54 | 1308 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004662.1567 | 2113418.8231 | 37.7833087728144 | -122.427560280444 | (37.7833087728144, -122.427560280444) | |||
102661 | 102661 | 117259 | Permitted Site 1 | :: 54 | 670 Eddy St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6007197.5 | 2113350.2 | 37.7832634280904 | -122.418784110751 | (37.7832634280904, -122.418784110751) | ||||
68734 | 68734 | 139765 | Undocumented 2 | :: 54 | 1306 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004663.7345 | 2113397.522 | 37.7832503745299 | -122.427553303818 | (37.7832503745299, -122.427553303818) | |||
145653 | 145653 | 140372 | Undocumented 2 | :: 54 | 1770 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002814.2684 | 2113417.5886 | 37.7832006898016 | -122.433953145391 | (37.7832006898016, -122.433953145391) | |||
5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
53717 | 53717 | 139776 | Undocumented 2 | :: 54 | 1275 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004800.935 | 2113296.4778 | 37.7829806915655 | -122.427071445409 | (37.7829806915655, -122.427071445409) | |||
5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
34038 | 34038 | 140392 | Undocumented 2 | :: 54 | 1460 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002728.4059 | 2113323.2276 | 37.782936725289204 | -122.434243446651 | (37.7829367252892, -122.434243446651) | |||
129582 | 129582 | 139105 | Undocumented 2 | :: 54 | 1310 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999792.0294 | 2113376.32 | 37.782915402867495 | -122.444405875371 | (37.7829154028675, -122.444405875371) | |||
98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
178124 | 178124 | 140889 | Undocumented 2 | :: 54 | 145 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996520.3624 | 2113408.7259 | 37.7828171689042 | -122.455726761043 | (37.7828171689042, -122.455726761043) | |||
177826 | 177826 | 140999 | Undocumented 2 | :: 54 | 2425 GEARY BLVD | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000127.896000001 | 2113280.4932 | 37.7826714447065 | -122.44323703523399 | (37.7826714447065, -122.443237035234) | |||
152366 | 152366 | 141748 | Undocumented 2 | :: 54 | 2 HOLLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004017.2728 | 2113191.4555 | 37.782647981182606 | -122.429775099989 | (37.7826479811826, -122.429775099989) | |||
56509 | 56509 | 139696 | Undocumented 2 | :: 54 | 345 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000314.3725 | 2113207.1569999997 | 37.7824807138402 | -122.442586640867 | (37.7824807138402, -122.442586640867) | |||
172823 | 172823 | 140400 | Undocumented 2 | :: 54 | 650 WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004364.2248 | 2113098.7472 | 37.782413067955495 | -122.428568183869 | (37.7824130679555, -122.428568183869) | |||
37419 | 37419 | 141003 | Undocumented 2 | :: 54 | 166 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996581.6168 | 2113251.3598 | 37.7823885984174 | -122.45550347026399 | (37.7823885984174, -122.455503470264) | |||
68816 | 68816 | 140401 | Undocumented 2 | :: 54 | 650 WILLOW ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004290.5512 | 2113088.0425 | 37.7823795059387 | -122.428822298842 | (37.7823795059387, -122.428822298842) | |||
41104 | 41104 | 140367 | Undocumented 2 | :: 54 | 690 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004237.6574 | 2113081.116 | 37.782357493618605 | -122.429004794114 | (37.7823574936186, -122.429004794114) | |||
148856 | 148856 | 139245 | Undocumented 2 | :: 54 | 1223 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003686.6496 | 2113074.8565 | 37.7823091017787 | -122.430910590356 | (37.7823091017787, -122.430910590356) | |||
131825 | 131825 | 141805 | Undocumented 2 | :: 54 | 1398 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004242.7853 | 2113058.4117 | 37.78229544352121 | -122.428985434597 | (37.7822954435212, -122.428985434597) | |||
164525 | 164525 | 137524 | Undocumented 2 | :: 54 | 1300 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002282.6726 | 2113052.5281 | 37.782168143964896 | -122.435766122963 | (37.7821681439649, -122.435766122963) | |||
131984 | 131984 | 201234 | Undocumented 2 | :: 54 | 795 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6012343.1682 | 2112809.9895 | 37.7820685155731 | -122.400944074647 | (37.7820685155731, -122.400944074647) | |||
39959 | 39959 | 141131 | Undocumented 2 | :: 54 | 1760 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002332.7569 | 2113004.3119 | 37.7820385992621 | -122.435589403585 | (37.7820385992621, -122.435589403585) | |||
73506 | 73506 | 140761 | Undocumented 2 | :: 54 | 18 Beideman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001559.8015 | 2112962.3476 | 37.7818794437174 | -122.43826046410801 | (37.7818794437174, -122.438260464108) | |||
31028 | 31028 | 139809 | Undocumented 2 | :: 54 | 1101 GOUGH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005660.0139 | 2112868.3262 | 37.7818536339515 | -122.424068925498 | (37.7818536339515, -122.424068925498) | |||
135552 | 135552 | 140125 | Undocumented 2 | :: 54 | 1321 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001271.8045 | 2112891.6174 | 37.7816688523257 | -122.43925172679899 | (37.7816688523257, -122.439251726799) | |||
28564 | 28564 | 139551 | Undocumented 2 | :: 54 | 230 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000668.9907 | 2112886.9641 | 37.7816217540269 | -122.441336837605 | (37.7816217540269, -122.441336837605) | |||
2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
52248 | 52248 | 140085 | Undocumented 2 | :: 54 | 220 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000673.3902 | 2112844.9998 | 37.7815067814228 | -122.44131860551799 | (37.7815067814228, -122.441318605518) | |||
28730 | 28730 | 140456 | Undocumented 2 | :: 54 | 1459 Eddy St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003479.0697 | 2112771.1641 | 37.7814634747388 | -122.431607035931 | (37.7814634747388, -122.431607035931) | |||
175934 | 175934 | 140091 | Undocumented 2 | :: 54 | 1250 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001831.6388 | 2112795.421 | 37.781436562836106 | -122.43730807844801 | (37.7814365628361, -122.437308078448) | |||
52820 | 52820 | 141107 | Undocumented 2 | :: 54 | 200 Parker Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997010.9048 | 2112879.9419 | 37.7813934068271 | -122.45399149831002 | (37.7813934068271, -122.45399149831) | |||
154987 | 154987 | 141117 | Undocumented 2 | :: 54 | 719 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997254.2301 | 2112852.8681 | 37.781333017932404 | -122.45314776051599 | (37.7813330179324, -122.453147760516) | |||
45872 | 45872 | 141030 | Undocumented 2 | :: 54 | 88 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998905.3901 | 2112810.7346 | 37.781311824276294 | -122.44743254381099 | (37.7813118242763, -122.447432543811) | |||
149950 | 149950 | 141106 | Undocumented 2 | :: 54 | 210 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997014.289 | 2112849.8223 | 37.781310900385996 | -122.45397761479201 | (37.781310900386, -122.453977614792) | |||
34444 | 34444 | 139926 | Undocumented 2 | :: 54 | 1001 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005215.378 | 2112666.1069 | 37.78127327564229 | -122.425592763682 | (37.7812732756423, -122.425592763682) | |||
31775 | 31775 | 141105 | Undocumented 2 | :: 54 | 220 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997021.7343 | 2112807.858 | 37.781196104366 | -122.45394882631399 | (37.781196104366, -122.453948826314) | |||
36850 | 36850 | 141882 | Undocumented 2 | :: 54 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | |||
24523 | 24523 | 141857 | Undocumented 2 | :: 54 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.781144690344895 | -122.42754147050199 | (37.7811446903449, -122.427541470502) | |||
131382 | 131382 | 141119 | Undocumented 2 | :: 54 | 124 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998714.1818 | 2112720.5452 | 37.7810532591781 | -122.448087532266 | (37.7810532591781, -122.448087532266) | |||
28027 | 28027 | 140087 | Undocumented 2 | :: 54 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001853.1286 | 2112643.6389 | 37.781021029267706 | -122.43722286326 | (37.7810210292677, -122.43722286326) | |||
183785 | 183785 | 141123 | Undocumented 2 | :: 54 | 144 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998637.0216 | 2112710.0541 | 37.7810200422428 | -122.448353710975 | (37.7810200422428, -122.448353710975) | |||
31430 | 31430 | 141865 | Undocumented 2 | :: 54 | 1198 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004361.706 | 2112589.3295 | 37.7810141909048 | -122.42854057505699 | (37.7810141909048, -122.428540575057) | |||
172874 | 172874 | 139933 | Undocumented 2 | :: 54 | 800 GOUGH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005708.0541 | 2112525.3709 | 37.7809146750444 | -122.42387833426001 | (37.7809146750444, -122.42387833426) |
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");