Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, PlotSize, PermitNotes
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25269 | 25269 | 135059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010565.46035 | 2122201.4821900004 | 37.807755957339396 | -122.40775658241999 | (37.8077559573394, -122.40775658242) | ||||
25686 | 25686 | 134476 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Larkin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007839.62129 | 2111720.04477 | 37.7788235475933 | -122.416447114449 | (37.7788235475933, -122.416447114449) | |||
26200 | 26200 | 195226 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 551 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6011058.60969 | 2097355.1094400003 | 37.739561139028 | -122.40429996976299 | (37.739561139028, -122.404299969763) | ||||
27969 | 27969 | 195211 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6010362.46324 | 2096499.30482 | 37.737172358017794 | -122.40664666073201 | (37.7371723580178, -122.406646660732) | |||
29123 | 29123 | 186920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985200.7204 | 2096727.014 | 37.73635770677671 | -122.493657794712 | (37.7363577067767, -122.493657794712) | |||
29192 | 29192 | 134920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6008362.41303 | 2121791.60977 | 37.806506977065794 | -122.415351749199 | (37.8065069770658, -122.415351749199) | |||
30713 | 30713 | 134493 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6008191.76515 | 2111982.49606 | 37.7795639729274 | -122.41524748988998 | (37.7795639729274, -122.41524748989) | |||
30847 | 30847 | 246610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 6009018.5431 | 2100356.10126 | 37.747686993058295 | -122.411565635751 | (37.7476869930583, -122.411565635751) | |||
31479 | 31479 | 195925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018989.61551 | 2093779.2666099998 | 37.7301825662676 | -122.376629714494 | (37.7301825662676, -122.376629714494) | ||||
31572 | 31572 | 134812 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007187.8206400005 | 2120917.39341 | 37.804040515307896 | -122.419354593866 | (37.8040405153079, -122.419354593866) | |||
31948 | 31948 | 135088 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010288.509880001 | 2122353.59437 | 37.8081581116658 | -122.40872577909201 | (37.8081581116658, -122.408725779092) | ||||
32513 | 32513 | 211872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5991819.38924 | 2106093.5806 | 37.7624608541941 | -122.471456804899 | (37.7624608541941, -122.471456804899) | |||
33244 | 33244 | 135096 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010210.74566 | 2122411.37483 | 37.808312406561896 | -122.40899898321501 | (37.8083124065619, -122.408998983215) | ||||
34032 | 34032 | 135097 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010211.1601599995 | 2122431.69205 | 37.8083682157885 | -122.408998983212 | (37.8083682157885, -122.408998983212) | ||||
34258 | 34258 | 135145 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6009594.12763 | 2122497.09351 | 37.808513208082 | -122.411139022559 | (37.808513208082, -122.411139022559) | ||||
34610 | 34610 | 134478 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Larkin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | |||
34886 | 34886 | 135069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010465.71952 | 2122256.12348 | 37.8079004046485 | -122.408105617404 | (37.8079004046485, -122.408105617404) | ||||
35182 | 35182 | 195197 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 180 Industrial St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 6011122.746040001 | 2097112.2887099998 | 37.738897988850105 | -122.404061128714 | (37.7388979888501, -122.404061128714) | |||
37873 | 37873 | 195921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6018012.35548 | 2092964.6692 | 37.72789197591621 | -122.379951686024 | (37.7278919759162, -122.379951686024) | |||
39613 | 39613 | 134925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6008346.87232 | 2121899.69009 | 37.8068028648324 | -122.415413187278 | (37.8068028648324, -122.415413187278) | |||
40408 | 40408 | 195193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 180 Industrial St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6011356.489709999 | 2097189.94333 | 37.739124269068796 | -122.403258408244 | (37.7391242690688, -122.403258408244) | |||
41387 | 41387 | 235338 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3125 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6008837.66692 | 2100528.02506 | 37.7481489100535 | -122.412203246977 | (37.7481489100535, -122.412203246977) | |||
41895 | 41895 | 135063 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010521.57842 | 2122228.08294 | 37.807826539739104 | -122.407910324225 | (37.8078265397391, -122.407910324225) | ||||
42182 | 42182 | 178526 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997920.74376 | 2086988.8754200002 | 37.710354990967105 | -122.448978278229 | (37.7103549909671, -122.448978278229) | |||
42690 | 42690 | 135067 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010487.41512 | 2122245.5184 | 37.8078725004725 | -122.40802978564899 | (37.8078725004725, -122.408029785649) | ||||
42897 | 42897 | 195207 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6010366.87736 | 2096397.5409900001 | 37.7368931832764 | -122.406624229832 | (37.7368931832764, -122.406624229832) | |||
43414 | 43414 | 134323 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1828 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6004706.30116 | 2117783.72452 | 37.795296191212 | -122.42771865761298 | (37.795296191212, -122.427718657613) | |||
43566 | 43566 | 234755 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 355 Buena Vista Ave East | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6001109.53037 | 2107914.1327299997 | 37.7679926965456 | -122.439456205157 | (37.7679926965456, -122.439456205157) | |||
45743 | 45743 | 135093 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010231.518209999 | 2122384.9462900003 | 37.8082410039906 | -122.408925228011 | (37.8082410039906, -122.408925228011) | ||||
46489 | 46489 | 135163 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6009340.6942 | 2122549.79423 | 37.8086436952141 | -122.412019829366 | (37.8086436952141, -122.412019829366) | ||||
46742 | 46742 | 134927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008339.114519999 | 2121958.1114 | 37.80696283893221 | -122.41544417341998 | (37.8069628389322, -122.41544417342) | |||
47779 | 47779 | 134482 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007900.29971 | 2111939.17847 | 37.7794286483426 | -122.416252727774 | (37.7794286483426, -122.416252727774) | |||
48582 | 48582 | 124186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5995895.66436 | 2112512.94419 | 37.7803217205181 | -122.45782309872601 | (37.7803217205181, -122.457823098726) | ||||
48936 | 48936 | 134813 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007179.40852 | 2120915.71213 | 37.8040354251579 | -122.419383585305 | (37.8040354251579, -122.419383585305) | |||
49067 | 49067 | 211873 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5991818.2499400005 | 2106106.5451599997 | 37.7624963855287 | -122.471461690004 | (37.7624963855287, -122.471461690004) | |||
50589 | 50589 | 195195 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 180 Industrial St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6011217.70897 | 2097143.60781 | 37.7389892898196 | -122.403734992288 | (37.7389892898196, -122.403734992288) | |||
50882 | 50882 | 134489 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008140.64601 | 2111978.12768 | 37.7795491053379 | -122.415424024093 | (37.7795491053379, -122.415424024093) | |||
51141 | 51141 | 134492 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008187.17961 | 2111997.187 | 37.779604053022204 | -122.415264393538 | (37.7796040530222, -122.415264393538) | |||
53095 | 53095 | 135139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009651.5635 | 2122485.8577099997 | 37.808485578225294 | -122.410939454894 | (37.8084855782253, -122.410939454894) | ||||
53299 | 53299 | 135061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010544.11345 | 2122214.47173 | 37.807790428346294 | -122.407831375437 | (37.8077904283463, -122.407831375437) | ||||
53876 | 53876 | 211871 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 14th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5991820.0903900005 | 2106059.80754 | 37.7623681628891 | -122.47145191888501 | (37.7623681628891, -122.471451918885) | |||
55689 | 55689 | 195228 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 411 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011234.22721 | 2097932.95922 | 37.7411576029413 | -122.40373340589 | (37.7411576029413, -122.40373340589) | ||||
55872 | 55872 | 178527 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 557 Ellington Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997931.98579 | 2086999.1742900002 | 37.7103839122559 | -122.448940164984 | (37.7103839122559, -122.448940164984) | |||
56177 | 56177 | 212773 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Locksley Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5994172.1399 | 2104745.68384 | 37.7588957050895 | -122.463221756972 | (37.7588957050895, -122.463221756972) | |||
56212 | 56212 | 246609 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6009017.88819 | 2100400.35104 | 37.747808456402204 | -122.411571026302 | (37.7478084564022, -122.411571026302) | |||
56641 | 56641 | 235337 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3125 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6008813.91968 | 2100528.00727 | 37.74814752868 | -122.41228536317499 | (37.74814752868, -122.412285363175) | |||
59638 | 59638 | 135156 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009480.72759 | 2122523.69804 | 37.808579897317706 | -122.411533357278 | (37.8085798973177, -122.411533357278) | ||||
61001 | 61001 | 135157 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009451.25096 | 2122529.40055 | 37.808593901544796 | -122.411635772999 | (37.8085939015448, -122.411635772999) | ||||
62159 | 62159 | 178536 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2134 San Jose Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5998755.19209 | 2090916.21978 | 37.7211862692206 | -122.44637660699499 | (37.7211862692206, -122.446376606995) | |||
62376 | 62376 | 195220 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Phelps St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6015550.3471800005 | 2098396.8135900004 | 37.7426714191664 | -122.388842057332 | (37.7426714191664, -122.388842057332) | ||||
63037 | 63037 | 134811 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007198.08423 | 2120918.57327 | 37.8040443329535 | -122.41931915967699 | (37.8040443329535, -122.419319159677) | |||
63977 | 63977 | 134810 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 864 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007208.980819999 | 2120920.35819 | 37.8040498475794 | -122.419281577887 | (37.8040498475794, -122.419281577887) | |||
65461 | 65461 | 246607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6009015.83407 | 2100452.3902 | 37.7479512291657 | -122.41158180555901 | (37.7479512291657, -122.411581805559) | |||
65986 | 65986 | 134488 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008103.05176 | 2111975.1886299998 | 37.7795389223209 | -122.415553870937 | (37.7795389223209, -122.415553870937) | |||
66068 | 66068 | 211978 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 345 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5995289.40634 | 2095286.26517 | 37.732986805287204 | -122.458672953709 | (37.7329868052872, -122.458672953709) | |||
67083 | 67083 | 249597 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Starr King Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6005903.20388 | 2113896.36406 | 37.7846901005097 | -122.42330070209199 | (37.7846901005097, -122.423300702092) | |||
67415 | 67415 | 135155 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009496.8532 | 2122519.11823 | 37.808568226806706 | -122.41147722608801 | (37.8085682268067, -122.411477226088) | ||||
67988 | 67988 | 184818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984694.627 | 2106957.5269 | 37.7644182648708 | -122.49616211163 | (37.7644182648708, -122.49616211163) | |||
68996 | 68996 | 135143 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009614.4871 | 2122492.8917400003 | 37.8085028128125 | -122.41106826569799 | (37.8085028128125, -122.411068265698) | ||||
69245 | 69245 | 135161 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009360.267630001 | 2122546.84411 | 37.808636693089106 | -122.411951881091 | (37.8086366930891, -122.411951881091) | ||||
71387 | 71387 | 246612 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 6009024.183540001 | 2100288.85536 | 37.747502667115995 | -122.411541381024 | (37.747502667116, -122.411541381024) | |||
72327 | 72327 | 246608 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 6009017.0349 | 2100422.64274 | 37.7478696166005 | -122.411575551688 | (37.7478696166005, -122.411575551688) | |||
72368 | 72368 | 195924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6017916.47309 | 2093037.8784299998 | 37.728087704366395 | -122.380288242927 | (37.7280877043664, -122.380288242927) | |||
72484 | 72484 | 195208 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6010365.684719999 | 2096419.1002599997 | 37.736952313694296 | -122.406629872173 | (37.7369523136943, -122.406629872173) | |||
73121 | 73121 | 135085 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010323.2303 | 2122334.05501 | 37.8081064060573 | -122.408604240196 | (37.8081064060573, -122.408604240196) | ||||
73253 | 73253 | 195922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6017988.36084 | 2092981.7840200001 | 37.7279376461829 | -122.38003582571899 | (37.7279376461829, -122.380035825719) | |||
73550 | 73550 | 135065 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010499.870619999 | 2122238.0904900003 | 37.8078528026406 | -122.407986155943 | (37.8078528026406, -122.407986155943) | ||||
73713 | 73713 | 195203 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6010373.75782 | 2096271.7348200001 | 37.7365481313758 | -122.406591578135 | (37.7365481313758, -122.406591578135) | |||
74075 | 74075 | 133978 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2663 Divisadero St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6000628.556580001 | 2117468.4117099997 | 37.7941989176091 | -122.44180563181801 | (37.7941989176091, -122.441805631818) | |||
74682 | 74682 | 211977 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 345 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5995293.06004 | 2095275.7744900002 | 37.7329582104325 | -122.458659562811 | (37.7329582104325, -122.458659562811) | |||
75529 | 75529 | 135077 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010393.83504 | 2122293.15944 | 37.8079980710226 | -122.40835700668998 | (37.8079980710226, -122.40835700669) | ||||
75955 | 75955 | 246611 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 6009019.66641 | 2100315.72215 | 37.7475761839871 | -122.41155889894199 | (37.7475761839871, -122.411558898942) | |||
75972 | 75972 | 195196 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 180 Industrial St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6011168.89021 | 2097127.13008 | 37.73894131818779 | -122.403902626815 | (37.7389413181878, -122.403902626815) | |||
75977 | 75977 | 212793 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 Joost Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 10ft | 6000061.547069999 | 2094934.9718099998 | 37.7322953606394 | -122.442149258277 | (37.7322953606394, -122.442149258277) | |||
77098 | 77098 | 134483 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007936.08027 | 2111955.66275 | 37.7794759221066 | -122.41613011511299 | (37.7794759221066, -122.416130115113) | |||
77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
90564 | 90564 | 100200 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095844.0 | 37.734679980307604 | -122.448958173673 | (37.7346799803076, -122.448958173673) | |||||
96282 | 96282 | 104677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 ZIRCON PL | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
96604 | 96604 | 115832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 30x30 | Permit Number 777501 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | ||
108723 | 108723 | 134479 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6007863.31951 | 2111948.54431 | 37.7794522852199 | -122.416381321833 | (37.7794522852199, -122.416381321833) | |||
117202 | 117202 | 113146 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5989923.85389835 | 2104457.9188665003 | 37.75785992656171 | -122.477893114522 | (37.7578599265617, -122.477893114522) | |||||
117806 | 117806 | 110559 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 320x FULTON ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x36 | 6006080.0 | 2112015.0 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | ||||
119495 | 119495 | 195204 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6010370.90721 | 2096339.74843 | 37.7367347227266 | -122.406606225391 | (37.7367347227266, -122.406606225391) | |||
119616 | 119616 | 110560 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 320x FULTON ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x36 | 6006080.0 | 2112015.0 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | ||||
123742 | 123742 | 195227 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 551 Barneveld Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6011061.62572 | 2097401.98447 | 37.739690016376294 | -122.404292839969 | (37.7396900163763, -122.404292839969) | ||||
125286 | 125286 | 66057 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/03/1990 12:00:00 AM | Permit Number 29097 | 5989923.85389835 | 2104457.9188665003 | 37.75785992656171 | -122.477893114522 | (37.7578599265617, -122.477893114522) | |||
127969 | 127969 | 100199 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095813.0 | 37.7345948616995 | -122.44895594133499 | (37.7345948616995, -122.448955941335) | |||||
128238 | 128238 | 195210 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6010362.19427 | 2096478.08812 | 37.737114086451605 | -122.406646095968 | (37.7371140864516, -122.406646095968) | |||
130521 | 130521 | 135075 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010411.666669999 | 2122284.4263400002 | 37.8079750906313 | -122.408294679165 | (37.8079750906313, -122.408294679165) | ||||
130915 | 130915 | 135090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010270.120709999 | 2122364.4312 | 37.808186836917294 | -122.40879018494199 | (37.8081868369173, -122.408790184942) | ||||
131198 | 131198 | 134491 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6008163.020330001 | 2111980.65153 | 37.7795572927687 | -122.41534680023001 | (37.7795572927687, -122.41534680023) | |||
133193 | 133193 | 195923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6017931.94783 | 2093024.26142 | 37.7280511685158 | -122.380233799755 | (37.7280511685158, -122.380233799755) | |||
135009 | 135009 | 135071 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010449.38794 | 2122264.82595 | 37.8079233850293 | -122.408162751324 | (37.8079233850293, -122.408162751324) | ||||
135484 | 135484 | 134878 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2431 Jones St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6007937.84589 | 2120885.23844 | 37.8039944394461 | -122.41675679331101 | (37.8039944394461, -122.416756793311) | |||
136362 | 136362 | 195206 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6010367.8344 | 2096379.27785 | 37.736843090144504 | -122.406619634286 | (37.7368430901445, -122.406619634286) | |||
136605 | 136605 | 134484 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007942.834559999 | 2111947.77669 | 37.7794546486445 | -122.416106190441 | (37.7794546486445, -122.416106190441) | |||
136976 | 136976 | 135167 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009297.39065 | 2122561.1634400003 | 37.8086724825285 | -122.41217049819201 | (37.8086724825285, -122.412170498192) | ||||
146170 | 146170 | 195205 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 625 Bay Shore Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6010368.31893 | 2096365.5520799998 | 37.73680542922371 | -122.40661699208 | (37.7368054292237, -122.40661699208) | |||
147168 | 147168 | 134490 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 Fulton St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008161.462669999 | 2111994.06404 | 37.779594032765296 | -122.41535313863001 | (37.7795940327653, -122.41535313863) | |||
149408 | 149408 | 135098 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010217.76574 | 2122446.50226 | 37.808409250946 | -122.408977168373 | (37.808409250946, -122.408977168373) |
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");