Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6273 | 6273 | 106722 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2905 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5999550.4676 | 2114295.9601 | 37.7854267102234 | -122.44530771900499 | (37.7854267102234, -122.445307719005) | |||
11042 | 11042 | 26800 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.5180000002 | 37.7119893605537 | -122.40595006858901 | (37.7119893605537, -122.405950068589) | ||
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) | |||
25034 | 25034 | 245135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 108 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000350.1465 | 2109371.4561 | 37.7719508943795 | -122.442187448391 | (37.7719508943795, -122.442187448391) | |||
25315 | 25315 | 214430 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1449 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994564.92824 | 2105667.42419 | 37.7614491861622 | -122.461930160573 | (37.7614491861622, -122.461930160573) | |||
25621 | 25621 | 178933 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000047.59686 | 2091609.71589 | 37.723164181455004 | -122.441958899679 | (37.723164181455, -122.441958899679) | |||
26914 | 26914 | 245213 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001001.539 | 2109303.6237 | 37.7718017456892 | -122.439929374343 | (37.7718017456892, -122.439929374343) | |||
30319 | 30319 | 237984 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 124 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004243.12433 | 2095170.9025700002 | 37.733180596596206 | -122.42770938917101 | (37.7331805965962, -122.427709389171) | |||
30791 | 30791 | 178956 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1393 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007451.98675 | 2091842.9041799998 | 37.724223625092 | -122.416379812775 | (37.724223625092, -122.416379812775) | |||
32181 | 32181 | 214447 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.21414 | 2099688.46118 | 37.7449632937192 | -122.465648504685 | (37.7449632937192, -122.465648504685) | |||
32627 | 32627 | 78659 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 5 | 5998369.991909999 | 2089313.5256400001 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | ||
32986 | 32986 | 245166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000067.3756 | 2109215.4243 | 37.771506350919296 | -122.443154362685 | (37.7715063509193, -122.443154362685) | |||
35134 | 35134 | 214474 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998536.47989 | 2093762.7157299998 | 37.7289895894874 | -122.447337400427 | (37.7289895894874, -122.447337400427) | ||||
35538 | 35538 | 196420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010086.24135 | 2110805.69337 | 37.776439037479896 | -122.408610616413 | (37.7764390374799, -122.408610616413) | |||
36893 | 36893 | 196422 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009795.26229 | 2111148.2090000003 | 37.7773632041902 | -122.409641380638 | (37.7773632041902, -122.409641380638) | |||
39187 | 39187 | 178946 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6005433.25 | 2093389.63985 | 37.7283568930528 | -122.42346820799 | (37.7283568930528, -122.42346820799) | |||
39304 | 39304 | 97751 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2478 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x6 | 5989249.1358 | 2098482.8133 | 37.741414683908 | -122.479789330113 | (37.741414683908, -122.479789330113) | |||
44877 | 44877 | 238005 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 118 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002126.98293 | 2096665.47856 | 37.7371644277915 | -122.435132311514 | (37.7371644277915, -122.435132311514) | |||
45819 | 45819 | 244240 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.0678 | 2110158.7025 | 37.774407460347796 | -122.424256515939 | (37.7744074603478, -122.424256515939) | |||
50224 | 50224 | 139387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005553.2038 | 2110871.2264 | 37.77636405517521 | -122.424296355394 | (37.7763640551752, -122.424296355394) | |||
51288 | 51288 | 244389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005653.9696 | 2110171.6272 | 37.774448814721104 | -122.42389801886002 | (37.7744488147211, -122.42389801886) | |||
52137 | 52137 | 138975 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 461 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005450.5842 | 2110864.9202 | 37.776340944809704 | -122.42465089693 | (37.7763409448097, -122.42465089693) | |||
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) | ||||
52586 | 52586 | 214452 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 115 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993881.37151 | 2099908.46331 | 37.7455971799806 | -122.463876248508 | (37.7455971799806, -122.463876248508) | |||
53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
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) | ||||
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) | |||
59715 | 59715 | 214434 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1519 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993346.59764 | 2105121.87087 | 37.7598810239214 | -122.466104180387 | (37.7598810239214, -122.466104180387) | |||
60280 | 60280 | 218132 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Lopez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5993993.8202 | 2100664.7541 | 37.747680242765895 | -122.463542297865 | (37.7476802427659, -122.463542297865) | |||
61372 | 61372 | 214427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 55 Cranleigh Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5991235.53196 | 2095666.85517 | 37.7337979784868 | -122.47271585846799 | (37.7337979784868, -122.472715858468) | |||
61750 | 61750 | 182581 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2462 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5989245.1110000005 | 2098590.7488 | 37.7417108128416 | -122.4798111426 | (37.7417108128416, -122.4798111426) | |||
65928 | 65928 | 238009 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1269 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5997476.9069 | 2105200.1672799997 | 37.7603334305535 | -122.45182517571199 | (37.7603334305535, -122.451825175712) | |||
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) | |||
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) | |||
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) | |||
75556 | 75556 | 214445 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992640.7022 | 2098905.58919 | 37.742771967855504 | -122.46809331884701 | (37.7427719678555, -122.468093318847) | |||
118173 | 118173 | 247294 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 836 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002133.2487 | 2109156.7194 | 37.771462740402995 | -122.436004206745 | (37.771462740403, -122.436004206745) | |||
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) | ||||
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) | |||
132824 | 132824 | 237988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005544.33972 | 2096386.4343299998 | 37.736591695453896 | -122.42329710838001 | (37.7365916954539, -122.42329710838) | |||
137247 | 137247 | 214448 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993355.75758 | 2099687.65001 | 37.744960578675794 | -122.46567768677001 | (37.7449605786758, -122.46567768677) | |||
146988 | 146988 | 238017 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5999577.21744 | 2106844.6450900002 | 37.7649688268778 | -122.444679408227 | (37.7649688268778, -122.444679408227) | |||
149092 | 149092 | 214429 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1455 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994567.088880001 | 2105628.96969 | 37.7613437244472 | -122.461919899305 | (37.7613437244472, -122.461919899305) | |||
149250 | 149250 | 214410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 319 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994311.31652 | 2098976.3234200003 | 37.7430625253047 | -122.462321980781 | (37.7430625253047, -122.462321980781) | |||
153848 | 153848 | 138873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 OCTAVIA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005564.9563 | 2110783.2259 | 37.7761230908013 | -122.42424943998002 | (37.7761230908013, -122.42424943998) | |||
153974 | 153974 | 214453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994424.22111 | 2100746.43892 | 37.7479293180792 | -122.462059929142 | (37.7479293180792, -122.462059929142) | |||
154712 | 154712 | 245028 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000516.7427 | 2109233.4639 | 37.7715814955912 | -122.441601276959 | (37.7715814955912, -122.441601276959) | |||
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) | ||||
155982 | 155982 | 245875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001285.051 | 2109638.8769 | 37.772738401980604 | -122.438972719673 | (37.7727384019806, -122.438972719673) | |||
156102 | 156102 | 214382 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1935 16th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5991235.497140001 | 2102232.23855 | 37.751824832267395 | -122.473194631436 | (37.7518248322674, -122.473194631436) | |||
157201 | 157201 | 139388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.9106 | 2110887.2787 | 37.776408001399496 | -122.42430543018601 | (37.7764080013995, -122.424305430186) | |||
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) | |||
160642 | 160642 | 214409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 319 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994299.528 | 2098982.87958 | 37.7430798480616 | -122.462363217409 | (37.7430798480616, -122.462363217409) | |||
164894 | 164894 | 137853 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003344.2833 | 2115489.023 | 37.788918389075704 | -122.432267493573 | (37.7889183890757, -122.432267493573) | |||
166733 | 166733 | 178880 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 641 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002434.092619999 | 2090051.35285 | 37.71902096971979 | -122.433597942217 | (37.7190209697198, -122.433597942217) | |||
169862 | 169862 | 214472 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6000443.47619 | 2094924.07855 | 37.732287209190396 | -122.44082806428499 | (37.7322872091904, -122.440828064285) | |||
170836 | 170836 | 244366 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005514.1663 | 2110403.406 | 37.7750773296011 | -122.424398114747 | (37.7750773296011, -122.424398114747) | |||
173041 | 173041 | 238003 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 860 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000870.32995 | 2102023.8969900003 | 37.7518059348134 | -122.439861199541 | (37.7518059348134, -122.439861199541) | |||
173321 | 173321 | 120192 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 372 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5987801.15874 | 2113459.16979 | 37.7824514349063 | -122.485894866545 | (37.7824514349063, -122.485894866545) | |||
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) | |||
179548 | 179548 | 73527 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5988189.2832 | 2100871.8604 | 37.747912746917 | -122.48362900134701 | (37.747912746917, -122.483629001347) | ||
183024 | 183024 | 185612 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2101 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985702.4651 | 2100891.7117 | 37.7478221885491 | -122.492229646849 | (37.7478221885491, -122.492229646849) | |||
184583 | 184583 | 214454 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 808 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000441.91889 | 2095870.2821900002 | 37.7348851751926 | -122.44090130146601 | (37.7348851751926, -122.440901301466) | |||
184820 | 184820 | 245887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 204 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001309.3147 | 2109461.0534 | 37.772251523616 | -122.438876043486 | (37.772251523616, -122.438876043486) | |||
187570 | 187570 | 244239 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 253 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005546.7389 | 2110177.0116 | 37.774457544735604 | -122.424269333697 | (37.7744575447356, -122.424269333697) | |||
188063 | 188063 | 142262 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004599.612000001 | 2110681.6144 | 37.77578953520371 | -122.42758158520701 | (37.7757895352037, -122.427581585207) | |||
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) | ||||
38530 | 38530 | 66212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2695 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1990 12:00:00 AM | 5 | Permit Number 29302 | 5988940.3934 | 2097023.2112 | 37.737389055247505 | -122.48075001046499 | (37.7373890552475, -122.480750010465) | ||
86060 | 86060 | 102208 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
104136 | 104136 | 102207 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
125650 | 125650 | 102209 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
157805 | 157805 | 36162 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 5 | Permit Number 39243 | 5997531.2283 | 2113294.3394 | 37.7825610537015 | -122.452221351103 | (37.7825610537015, -122.452221351103) | |
73741 | 73741 | 37222 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2075 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39786 | 5986006.8021 | 2101124.4403 | 37.748478985005896 | -122.49119440423401 | (37.7484789850059, -122.491194404234) | |
46491 | 46491 | 38115 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1342 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | 5 | Permit Number 40279 | 5987120.6367 | 2106124.4711 | 37.7622727278914 | -122.487710118761 | (37.7622727278914, -122.487710118761) | |
59112 | 59112 | 40021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.73523191912879 | -122.387929152323 | (37.7352319191288, -122.387929152323) | |
43817 | 43817 | 43193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 42992 | 6007883.41814 | 2094225.91699 | 37.7307911186019 | -122.415057008091 | (37.7307911186019, -122.415057008091) | ||
136384 | 136384 | 43239 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1486 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43026 | 5988082.3365 | 2105208.3071 | 37.7598132372762 | -122.48431680666201 | (37.7598132372762, -122.484316806662) | ||
41098 | 41098 | 45065 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | 5 | Permit Number 43947 | 5987876.0483 | 2100960.5293 | 37.7481379705415 | -122.484718643564 | (37.7481379705415, -122.484718643564) | ||
134704 | 134704 | 45075 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2118 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 5 | Permit Number 43957 | 5987613.4283 | 2100841.7317 | 37.747796485779396 | -122.48561804583099 | (37.7477964857794, -122.485618045831) | |
56684 | 56684 | 44186 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 792 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45643 | 6004083.1428 | 2110821.1912 | 37.7761435523821 | -122.429378138275 | (37.7761435523821, -122.429378138275) |
187269 | 187269 | 49212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | |
62567 | 62567 | 49556 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 50 Arco Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 5 | Permit Number 46445 | 5999433.50359 | 2093069.00775 | 37.727136046271895 | -122.44418650420499 | (37.7271360462719, -122.444186504205) | ||
129520 | 129520 | 49559 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Arco Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 5 | Permit Number 46448 | 5999473.40904 | 2093111.37825 | 37.72725466236621 | -122.444051595127 | (37.7272546623662, -122.444051595127) | ||
99465 | 99465 | 52811 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 236 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 4x4 | Permit Number 51538 | 6002040.43220631 | 2104480.2641092 | 37.7586170657689 | -122.435990581738 | (37.7586170657689, -122.435990581738) | |
129001 | 129001 | 52812 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 236 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 4x4 | Permit Number 51538 | 6002040.43220631 | 2104480.2641092 | 37.7586170657689 | -122.435990581738 | (37.7586170657689, -122.435990581738) | |
27021 | 27021 | 95729 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) |
116861 | 116861 | 39163 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301x Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 5 | Permit Number 778831 | 6003629.0 | 2104450.0 | 37.758624085440104 | -122.43049443639099 | (37.7586240854401, -122.430494436391) |
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");