Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
| 173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
| 68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
| 75257 | 75257 | 186812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.764283401100705 | -122.495707883417 | (37.7642834011007, -122.495707883417) | |||
| 155382 | 155382 | 186813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 114 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.8556 | 2106897.4567 | 37.7642606048812 | -122.4957280144 | (37.7642606048812, -122.4957280144) | |||
| 58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
| 146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
| 43104 | 43104 | 178921 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993794.96049 | 2086770.14434 | 37.7095175863374 | -122.463221875682 | (37.7095175863374, -122.463221875682) | ||||
| 52553 | 52553 | 249684 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999742.6330699995 | 2117264.679 | 37.793589001891796 | -122.44485636243 | (37.7935890018918, -122.44485636243) | ||||
| 54903 | 54903 | 249683 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.44485371304701 | (37.7935581209611, -122.444853713047) | ||||
| 58079 | 58079 | 178920 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5993797.37837 | 2086767.25523 | 37.7095097928145 | -122.463213309645 | (37.7095097928145, -122.463213309645) | ||||
| 160772 | 160772 | 139415 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004014.3477 | 2114015.4334 | 37.7849102527835 | -122.429844011157 | (37.7849102527835, -122.429844011157) | |||
| 4281 | 4281 | 139414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:29:00 AM | 3 | Width 0ft | 6004053.5092 | 2114020.2427 | 37.7849256755107 | -122.42970886814301 | (37.7849256755107, -122.429708868143) | ||
| 75178 | 75178 | 141139 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1915 Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002239.2415 | 2113631.2046 | 37.7837545758984 | -122.43595779441002 | (37.7837545758984, -122.43595779441) | |||
| 141683 | 141683 | 8518 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2099X Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | ||
| 155097 | 155097 | 178919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5993793.90715 | 2086767.20458 | 37.709509453768604 | -122.463225303004 | (37.7095094537686, -122.463225303004) | ||||
| 188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | ||||
| 36214 | 36214 | 139413 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004104.3504 | 2114027.1131 | 37.7849474186562 | -122.429533464104 | (37.7849474186562, -122.429533464104) | |||
| 48579 | 48579 | 178918 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.015380001 | 2086765.64003 | 37.709505048900496 | -122.46323172778 | (37.7095050489005, -122.46323172778) | ||||
| 130597 | 130597 | 214411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Ulloa St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995342.99314 | 2098250.4042599997 | 37.74112868343371 | -122.45870220413799 | (37.7411286834337, -122.458702204138) | |||
| 154849 | 154849 | 135905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6006460.32075 | 2121020.9303099997 | 37.804283800830795 | -122.42187952052099 | (37.8042838008308, -122.421879520521) | |||
| 68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
| 126076 | 126076 | 110554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 129644 | 129644 | 214463 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 714 Detroit St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999453.46925 | 2095428.5374599998 | 37.733615902639706 | -122.44428697109 | (37.7336159026397, -122.44428697109) | ||||
| 131732 | 131732 | 137957 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1615 SUTTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004849.7424 | 2114694.4909 | 37.7868220473623 | -122.427002194935 | (37.7868220473623, -122.427002194935) | |||
| 156598 | 156598 | 106989 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003919.5496 | 2114210.5022 | 37.7854404939773 | -122.430185903176 | (37.7854404939773, -122.430185903176) | |||
| 183985 | 183985 | 178917 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | ||||
| 25207 | 25207 | 214407 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5993812.00581 | 2096497.7556200002 | 37.7362282335302 | -122.463868579087 | (37.7362282335302, -122.463868579087) | ||||
| 65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
| 70200 | 70200 | 238029 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997725.71934 | 2106149.10788 | 37.76295322943079 | -122.45103308431601 | (37.7629532294308, -122.451033084316) | |||
| 80506 | 80506 | 27758 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 126397 | 126397 | 110553 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 131822 | 131822 | 178888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003758.58722 | 2090633.91893 | 37.7206956305865 | -122.42906119342501 | (37.7206956305865, -122.429061193425) | |||
| 132802 | 132802 | 106988 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003903.841 | 2114208.5386 | 37.7854342126943 | -122.43024011010401 | (37.7854342126943, -122.430240110104) | |||
| 133307 | 133307 | 137970 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 POST ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004704.8729 | 2114380.3573 | 37.785951322241004 | -122.42748102225401 | (37.785951322241, -122.427481022254) | |||
| 4250 | 4250 | 139410 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 10:27:00 AM | 3 | Width 0ft | 6004177.291 | 2114035.4814 | 37.78497452552379 | -122.429281709952 | (37.7849745255238, -122.429281709952) | ||
| 8595 | 8595 | 28648 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003548.747 | 2114394.8281 | 37.7859255976047 | -122.43148193261601 | (37.7859255976047, -122.431481932616) | ||
| 24204 | 24204 | 238028 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997698.52987 | 2106146.63858 | 37.7629448927014 | -122.45112694477699 | (37.7629448927014, -122.451126944777) | |||
| 52167 | 52167 | 214406 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993802.78615 | 2096495.7432 | 37.736222176613104 | -122.463900308969 | (37.7362221766131, -122.463900308969) | ||||
| 66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
| 80435 | 80435 | 110552 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 90524 | 90524 | 21708 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1710X Webster St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 7 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | ||
| 116099 | 116099 | 39071 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2280X Alameda St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | 3x3 | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | ||
| 123382 | 123382 | 50541 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 152192 | 152192 | 137955 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1615 SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004810.4247 | 2114689.3847 | 37.786805803696204 | -122.42713786122299 | (37.7868058036962, -122.427137861223) | |||
| 184613 | 184613 | 178887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003747.16271 | 2090614.46015 | 37.720641554351296 | -122.429099297695 | (37.7206415543513, -122.429099297695) | |||
| 4331 | 4331 | 87404 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003683.0746 | 2113412.9921 | 37.783237334948105 | -122.43094709822701 | (37.7832373349481, -122.430947098227) | ||
| 4516 | 4516 | 28647 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.785885930849204 | -122.431484021877 | (37.7858859308492, -122.431484021877) | |||
| 52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
| 59335 | 59335 | 139409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004207.1311 | 2114038.5263 | 37.7849845753314 | -122.42917868992501 | (37.7849845753314, -122.429178689925) | |||
| 66160 | 66160 | 214405 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993807.85396 | 2096495.9519200001 | 37.73622304175571 | -122.46388280274701 | (37.7362230417557, -122.463882802747) | ||||
| 77162 | 77162 | 42763 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 92173 | 92173 | 21707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1710X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 6 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | ||
| 113534 | 113534 | 110551 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 119846 | 119846 | 238027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997671.60097 | 2106142.0382 | 37.7629307194099 | -122.45121975030199 | (37.7629307194099, -122.451219750302) | |||
| 138781 | 138781 | 50542 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 142612 | 142612 | 39078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2280X Alameda St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | |||
| 154865 | 154865 | 139183 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1900 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002330.6115 | 2113779.5111 | 37.784166978068 | -122.435652302842 | (37.784166978068, -122.435652302842) | |||
| 159261 | 159261 | 138102 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1760 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003533.9856 | 2114838.2776 | 37.787142361314295 | -122.43156467310301 | (37.7871423613143, -122.431564673103) | |||
| 178144 | 178144 | 178886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.42914636912501 | (37.7205786116989, -122.429146369125) | |||
| 5350 | 5350 | 28646 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003557.7645 | 2114374.9896 | 37.7858716371659 | -122.431449317827 | (37.7858716371659, -122.431449317827) | |||
| 5618 | 5618 | 87403 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | ||
| 35667 | 35667 | 138101 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1750 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003541.5257 | 2114778.8993 | 37.7869797508763 | -122.43153434535401 | (37.7869797508763, -122.431534345354) | |||
| 67840 | 67840 | 183942 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1805 Quintara St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987837.1544 | 2100978.5872 | 37.748185287488496 | -122.484854460213 | (37.7481852874885, -122.484854460213) | |||
| 72821 | 72821 | 178885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003721.71366 | 2090575.2726099999 | 37.720532513349106 | -122.42918447430401 | (37.7205325133491, -122.429184474304) | |||
| 85172 | 85172 | 43003 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Rose St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 85562 | 85562 | 42761 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 87728 | 87728 | 37253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4200 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 98435 | 98435 | 36038 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1660X BRYANT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | 2 | Permit Number 39178 | 6009346.0 | 2106886.0 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | ||
| 104105 | 104105 | 42375 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 601 Foerster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42549 | 5998097.42751354 | 2095265.42548706 | 37.733090576245104 | -122.448963434318 | (37.7330905762451, -122.448963434318) | ||
| 109151 | 109151 | 88233 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
| 109513 | 109513 | 50543 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 111214 | 111214 | 117171 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 126246 | 126246 | 110550 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 146849 | 146849 | 106987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003830.0102 | 2114195.5789 | 37.78539444652429 | -122.430494617565 | (37.7853944465243, -122.430494617565) | |||
| 151489 | 151489 | 238026 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997640.69708 | 2106136.91348 | 37.7629148787356 | -122.45132626601801 | (37.7629148787356, -122.451326266018) | |||
| 168201 | 168201 | 38758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012273.2979999995 | 2112461.93462 | 37.7811089398776 | -122.401161330453 | (37.7811089398776, -122.401161330453) | ||
| 168823 | 168823 | 137953 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1615 SUTTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004788.4681 | 2114683.7679 | 37.786789139709 | -122.427213425712 | (37.786789139709, -122.427213425712) | |||
| 23661 | 23661 | 142764 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.801741456909596 | -122.40695573845899 | (37.8017414569096, -122.406955738459) | |||
| 26263 | 26263 | 23904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6003550.0996 | 2114363.7178 | 37.7858402532263 | -122.43147503127199 | (37.7858402532263, -122.431475031272) | |||
| 31626 | 31626 | 106986 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003814.6942 | 2114193.6153 | 37.7853881873399 | -122.430547466156 | (37.7853881873399, -122.430547466156) | |||
| 35994 | 35994 | 138977 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005455.7439 | 2110835.1089 | 37.7762593816337 | -122.42463092693501 | (37.7762593816337, -122.424630926935) | |||
| 43907 | 43907 | 139147 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004351.7938 | 2114062.4276 | 37.785058390527794 | -122.428679907469 | (37.7850583905278, -122.428679907469) | |||
| 44048 | 44048 | 37254 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4200 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 46837 | 46837 | 178884 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003708.27118 | 2090552.3037299998 | 37.720468684870504 | -122.42922930371599 | (37.7204686848705, -122.429229303716) | |||
| 50185 | 50185 | 238001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 591 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002762.01889 | 2100032.1411900003 | 37.746444541887705 | -122.43317718719601 | (37.7464445418877, -122.433177187196) | ||||
| 57526 | 57526 | 244352 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005613.5532 | 2110456.5225 | 37.7752287864343 | -122.42405809140699 | (37.7752287864343, -122.424058091407) | |||
| 58675 | 58675 | 110549 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 70625 | 70625 | 178891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 579 Madrid St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.720437599790394 | -122.43356984466999 | (37.7204375997904, -122.43356984467) | |||
| 71170 | 71170 | 244253 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005660.0799 | 2110124.2725 | 37.7743191351223 | -122.423873514167 | (37.7743191351223, -122.423873514167) | |||
| 78486 | 78486 | 117170 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 83464 | 83464 | 119866 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 96072 | 96072 | 109161 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 98133 | 98133 | 88232 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
| 100422 | 100422 | 36248 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Surrey St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
| 102071 | 102071 | 50544 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 103110 | 103110 | 48786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1405 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 104070 | 104070 | 119873 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 107830 | 107830 | 4033 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) |
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");