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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51584 | 51584 | 223765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6009530.59471 | 2097856.4038 | 37.7408520807582 | -122.409618578357 | (37.7408520807582, -122.409618578357) | |||
170557 | 170557 | 223763 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.740878707894296 | -122.409618578334 | (37.7408787078943, -122.409618578334) | |||
174648 | 174648 | 223764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.40961857835899 | (37.7408634922583, -122.409618578359) | |||
82039 | 82039 | 116084 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.46045458158301 | (37.7430561859317, -122.460454581583) | |||
25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
34768 | 34768 | 247991 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 10ft | 6009914.62518 | 2099827.74346 | 37.7462864617583 | -122.408429756449 | (37.7462864617583, -122.408429756449) | |||
65231 | 65231 | 247990 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 10ft | 6009904.82703 | 2099823.3195700003 | 37.7462737660155 | -122.40846332542499 | (37.7462737660155, -122.408463325425) | |||
161313 | 161313 | 122257 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5991472.5237300005 | 2113448.5530000003 | 37.78263554306471 | -122.473192897736 | (37.7826355430647, -122.473192897736) | |||
27191 | 27191 | 186631 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.50933003298901 | (37.7606954284135, -122.509330032989) | |||
73687 | 73687 | 186630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.50932679385099 | (37.7606655657469, -122.509326793851) | |||
153024 | 153024 | 186626 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980879.19 | 2105650.5288 | 37.7606053983358 | -122.509261346313 | (37.7606053983358, -122.509261346313) | |||
155462 | 155462 | 186632 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | |||
174389 | 174389 | 186633 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | |||
76309 | 76309 | 181531 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984868.057999999 | 2105762.174 | 37.7611463180726 | -122.495474102719 | (37.7611463180726, -122.495474102719) | |||
77038 | 77038 | 181564 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5984848.6101 | 2106094.3132 | 37.7620571406013 | -122.495565861947 | (37.7620571406013, -122.495565861947) | |||
147268 | 147268 | 181534 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984871.9567 | 2105787.2372 | 37.7612153629002 | -122.495462467531 | (37.7612153629002, -122.495462467531) | |||
154075 | 154075 | 186715 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5984865.9056 | 2106138.7766 | 37.7621802374114 | -122.495509323915 | (37.7621802374114, -122.495509323915) | |||
165378 | 165378 | 181525 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984861.3745 | 2105743.7944 | 37.761095461476 | -122.49549586212 | (37.761095461476, -122.49549586212) | |||
12637 | 12637 | 19441 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 5986928.6035 | 2095895.7656 | 37.7341762495639 | -122.487622811763 | (37.7341762495639, -122.487622811763) | |||
28097 | 28097 | 184746 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984670.325 | 2106153.0915 | 37.7622080878104 | -122.49618680876499 | (37.7622080878104, -122.496186808765) | |||
36127 | 36127 | 184802 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 0ft | 5984710.1955 | 2105740.9062 | 37.7610786777919 | -122.496018504161 | (37.7610786777919, -122.496018504161) | |||
38529 | 38529 | 184787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5984684.7543 | 2105859.3786 | 37.7614024796931 | -122.49611523377199 | (37.7614024796931, -122.496115233772) | |||
44201 | 44201 | 184765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 0ft | 5984675.641 | 2106093.0958 | 37.7620436678288 | -122.496163996397 | (37.7620436678288, -122.496163996397) | |||
51736 | 51736 | 184793 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5984699.9431 | 2105830.5199 | 37.7613241314326 | -122.49606057370801 | (37.7613241314326, -122.496060573708) | |||
70817 | 70817 | 184775 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 0ft | 5984678.6788 | 2105968.358 | 37.7617013507315 | -122.49614428665701 | (37.7617013507315, -122.496144286657) | |||
71097 | 71097 | 184768 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 78 | Width 0ft | 5984699.3735 | 2106071.8316 | 37.761986672397 | -122.496080347248 | (37.761986672397, -122.496080347248) | |||
131941 | 131941 | 184792 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984699.5634 | 2105839.2535 | 37.76134808921321 | -122.496062531256 | (37.7613480892132, -122.496062531256) | |||
148614 | 148614 | 184757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 0ft | 5984673.5526 | 2106021.7086 | 37.7618475362622 | -122.496165952154 | (37.7618475362622, -122.496165952154) | |||
149256 | 149256 | 184738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 61 | Width 0ft | 5984659.3131 | 2106254.4766 | 37.7624858178148 | -122.496232374853 | (37.7624858178148, -122.496232374853) | |||
159421 | 159421 | 184771 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 0ft | 5984696.1459 | 2106000.2545 | 37.7617899526918 | -122.496086229193 | (37.7617899526918, -122.496086229193) | |||
164855 | 164855 | 184783 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984690.4501 | 2105882.5415 | 37.761466412150995 | -122.496097243606 | (37.761466412151, -122.496097243606) | |||
164893 | 164893 | 184780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 69 | Width 0ft | 5984672.982999999 | 2105911.7799 | 37.7615456694917 | -122.496159811415 | (37.7615456694917, -122.496159811415) | |||
171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
174207 | 174207 | 184747 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 0ft | 5984699.9431 | 2106151.5726 | 37.7622056521899 | -122.496084260471 | (37.7622056521899, -122.496084260471) | |||
176454 | 176454 | 184779 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5984701.0822 | 2105928.8672 | 37.7615942322964 | -122.496063889935 | (37.7615942322964, -122.496063889935) | |||
186424 | 186424 | 184800 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984686.2732 | 2105775.8403 | 37.76117319587821 | -122.496103817218 | (37.7611731958782, -122.496103817218) | |||
19244 | 19244 | 20545 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
79366 | 79366 | 20549 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
85580 | 85580 | 20539 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
94781 | 94781 | 20541 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
96354 | 96354 | 20544 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
96636 | 96636 | 20528 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
96863 | 96863 | 20540 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
102455 | 102455 | 20538 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
108770 | 108770 | 20531 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
111174 | 111174 | 20524 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
115048 | 115048 | 20527 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
115611 | 115611 | 20542 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
116613 | 116613 | 20526 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
127519 | 127519 | 20547 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
139297 | 139297 | 20530 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
142008 | 142008 | 20523 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
146309 | 146309 | 20535 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
25946 | 25946 | 126425 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6011438.821769999 | 2120037.4711599997 | 37.8018629670555 | -122.40458165273701 | (37.8018629670555, -122.404581652737) | |||
39759 | 39759 | 126424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011439.456040001 | 2120033.94187 | 37.801853311934096 | -122.404579209268 | (37.8018533119341, -122.404579209268) | |||
144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
188106 | 188106 | 205877 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5993571.02759 | 2097763.88788 | 37.7396908266808 | -122.464793651423 | (37.7396908266808, -122.464793651423) | |||
140844 | 140844 | 102706 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1342 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | |||||
134401 | 134401 | 206911 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 135 Montecito Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996442.52458 | 2094243.93157 | 37.730191016279 | -122.45461107036999 | (37.730191016279, -122.45461107037) | |||
38782 | 38782 | 139327 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6005396.3086 | 2114138.3218 | 37.785325835852795 | -122.425071614426 | (37.7853258358528, -122.425071614426) | |||
54250 | 54250 | 139328 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6005318.1985 | 2114131.1202 | 37.7853016493854 | -122.42534133927 | (37.7853016493854, -122.42534133927) | |||
72905 | 72905 | 139357 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1350x GEARY BLVD | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6005019.8844 | 2114088.1873 | 37.785166908017004 | -122.426370358064 | (37.785166908017, -122.426370358064) | |||
120332 | 120332 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1365 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | ||||
682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
90982 | 90982 | 20574 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
99122 | 99122 | 20576 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
99295 | 99295 | 20577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
117082 | 117082 | 20566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1392X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
58790 | 58790 | 205909 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000896.43949 | 2095509.3176099998 | 37.733919926568106 | -122.43930400388399 | (37.7339199265681, -122.439304003884) | ||||
9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
141192 | 141192 | 108958 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 22ND AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5989329.4 | 2105769.6 | 37.7614269305246 | -122.48004495307501 | (37.7614269305246, -122.480044953075) | ||||
166154 | 166154 | 186488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Lower Great Hwy | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5980888.4423 | 2105382.2174 | 37.7598692379346 | -122.50920942183998 | (37.7598692379346, -122.50920942184) | |||
23551 | 23551 | 181443 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984892.2857 | 2105061.2409 | 37.759223169955796 | -122.495338616437 | (37.7592231699558, -122.495338616437) | |||
29359 | 29359 | 181512 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984867.501 | 2105563.3396 | 37.760600341747896 | -122.495461364037 | (37.7606003417479, -122.495461364037) | |||
35059 | 35059 | 181449 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984873.9061 | 2105087.418 | 37.759293968823705 | -122.49540411159401 | (37.7592939688237, -122.495404111594) | |||
41016 | 41016 | 181468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984882.2605 | 2105242.2526 | 37.7597195906535 | -122.49538663760599 | (37.7597195906535, -122.495386637606) | |||
63714 | 63714 | 181514 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 0ft | 5984875.8554 | 2105578.3775 | 37.7606421208046 | -122.49543357949301 | (37.7606421208046, -122.495433579493) | |||
132817 | 132817 | 181506 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984860.5391 | 2105486.2008 | 37.76038813249 | -122.495479752328 | (37.76038813249, -122.495479752328) | |||
137097 | 137097 | 181441 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984891.7288 | 2105036.7347 | 37.759155850149 | -122.49533873513501 | (37.759155850149, -122.495338735135) | |||
149399 | 149399 | 181508 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984873.9061 | 2105511.8209 | 37.760459260826295 | -122.495435412339 | (37.7604592608263, -122.495435412339) | |||
149872 | 149872 | 181469 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984881.7035 | 2105250.0501 | 37.759740967801 | -122.495389139039 | (37.759740967801, -122.495389139039) | |||
155838 | 155838 | 181502 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984910.6654 | 2105475.0616 | 37.7603604823662 | -122.495305569795 | (37.7603604823662, -122.495305569795) | |||
163323 | 163323 | 181509 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984883.3744 | 2105527.9727 | 37.7605041635582 | -122.495403857574 | (37.7605041635582, -122.495403857574) | |||
170927 | 170927 | 181465 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984920.1337 | 2105218.8604 | 37.7596575796755 | -122.495253929823 | (37.7596575796755, -122.495253929823) | |||
177404 | 177404 | 181475 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984869.4504 | 2105277.3411 | 37.75981518382329 | -122.49543352861299 | (37.7598151838233, -122.495433528613) | |||
182159 | 182159 | 181511 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984874.1846 | 2105548.3017 | 37.7605594432249 | -122.495437139743 | (37.7605594432249, -122.495437139743) | |||
184501 | 184501 | 181442 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984907.8806 | 2105046.76 | 37.7591843225176 | -122.495283614644 | (37.7591843225176, -122.495283614644) | |||
186166 | 186166 | 181496 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984867.2226 | 2105416.0239 | 37.7601958376586 | -122.495451461713 | (37.7601958376586, -122.495451461713) | |||
47567 | 47567 | 186662 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984707.1311 | 2105554.3882 | 37.7605663720512 | -122.496015341954 | (37.7605663720512, -122.496015341954) | |||
62460 | 62460 | 186665 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984729.1141 | 2105540.7797 | 37.760530294446504 | -122.495938309988 | (37.7605302944465, -122.495938309988) | |||
66207 | 66207 | 186686 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984721.1583 | 2105332.5693 | 37.7599581409009 | -122.49595046480499 | (37.7599581409009, -122.495950464805) | |||
69733 | 69733 | 186694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984719.2741 | 2105229.7727 | 37.75967577978221 | -122.495949397724 | (37.7596757797822, -122.495949397724) | |||
166337 | 166337 | 186697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 61 | Width 0ft | 5984719.6928 | 2105196.6935 | 37.75958497805411 | -122.495945509363 | (37.7595849780541, -122.495945509363) | |||
178161 | 178161 | 186708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984718.4366 | 2105053.49 | 37.7591917076208 | -122.49593928954901 | (37.7591917076208, -122.495939289549) | |||
63703 | 63703 | 126423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 The Embarcadero | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6010525.17738 | 2122242.65614 | 37.8078667556044 | -122.40789889741899 | (37.8078667556044, -122.407898897419) | ||||
84848 | 84848 | 20592 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) |
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");