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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1012 | 1012 | 246499 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.833380001 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | |
1259 | 1259 | 238460 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 52 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779768 | 6002902.99046 | 2108581.89909 | 37.7699281239255 | -122.433300551682 | (37.7699281239255, -122.433300551682) | |
1472 | 1472 | 244877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1349 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000105.0 | 2109153.0 | 37.7713370947812 | -122.443019734512 | (37.7713370947812, -122.443019734512) | |||
3218 | 3218 | 139416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1701 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2014 12:00:00 AM | 3 | Width 0ft | 6004006.3401 | 2114230.9234 | 37.7855014808051 | -122.429887091087 | (37.7855014808051, -122.429887091087) | ||
3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
4145 | 4145 | 113403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006463.2485 | 2117908.2188 | 37.7957372487994 | -122.42164817262501 | (37.7957372487994, -122.421648172625) | |||
4166 | 4166 | 143128 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006467.2287 | 2117887.8753 | 37.795681615093 | -122.421632954779 | (37.795681615093, -122.421632954779) | |||
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) | ||
5979 | 5979 | 98098 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006897.32558 | 2115510.94052 | 37.789179385771604 | -122.41997598040399 | (37.7891793857716, -122.419975980404) | |||
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) | |||
6354 | 6354 | 98096 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006843.26628 | 2115504.44745 | 37.789158511592 | -122.420162558272 | (37.789158511592, -122.420162558272) | |||
8106 | 8106 | 114661 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1603 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | 3x3 | 6004477.5231 | 2114370.1159 | 37.7859103404926 | -122.42826686028299 | (37.7859103404926, -122.428266860283) | ||
8560 | 8560 | 98097 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.789170503156704 | -122.420050723983 | (37.7891705031567, -122.420050723983) | |||
8638 | 8638 | 98095 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006820.270769999 | 2115499.9051599996 | 37.789144743881295 | -122.420241797518 | (37.7891447438813, -122.420241797518) | |||
8790 | 8790 | 105143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | DPW for City Agency 2 | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.776309122873705 | -122.42428501193301 | (37.7763091228737, -122.424285011933) | ||
9626 | 9626 | 173611 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6005304.0 | 2101328.0 | 37.7501465436699 | -122.424479453971 | (37.7501465436699, -122.424479453971) | |||
10144 | 10144 | 173880 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1922 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998581.0 | 2110425.0 | 37.7747426714218 | -122.448382913575 | (37.7747426714218, -122.448382913575) | ||||
10200 | 10200 | 122374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
12422 | 12422 | 70297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856001 | (37.7316793628021, -122.43083747856) | ||
12916 | 12916 | 72155 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.4658699995 | 2093545.19578 | 37.7285261634496 | -122.43920812806499 | (37.7285261634496, -122.439208128065) | |
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) | |||
23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
23801 | 23801 | 183452 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2519 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989212.0936 | 2098169.1351 | 37.7405512532287 | -122.479894458871 | (37.7405512532287, -122.479894458871) | |||
23893 | 23893 | 238011 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 170 Upper Ter | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999678.6983900005 | 2106620.27376 | 37.7643585496334 | -122.444312287003 | (37.7643585496334, -122.444312287003) | |||
23946 | 23946 | 113286 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1626 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002122.0899 | 2114184.377 | 37.7852667906839 | -122.43640269829099 | (37.7852667906839, -122.436402698291) | |||
24060 | 24060 | 182205 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988079.8655 | 2104054.0379 | 37.756643783163206 | -122.484240699303 | (37.7566437831632, -122.484240699303) | |||
24062 | 24062 | 237974 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6005423.51837 | 2102260.48733 | 37.752713687090896 | -122.424132459851 | (37.7527136870909, -122.424132459851) | |||
24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
24195 | 24195 | 244515 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003699.3803 | 2109847.5959 | 37.7734485650794 | -122.430636186348 | (37.7734485650794, -122.430636186348) | |||
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) | |||
24350 | 24350 | 214468 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5997445.526980001 | 2095470.2100900002 | 37.7336155617911 | -122.451231980178 | (37.7336155617911, -122.451231980178) | |||
24369 | 24369 | 237998 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 338 Hoffman Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000611.91644 | 2101788.98208 | 37.7511462020375 | -122.440737977395 | (37.7511462020375, -122.440737977395) | |||
24617 | 24617 | 181947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988027.6673 | 2098939.5018 | 37.7425975937033 | -122.484046173892 | (37.7425975937033, -122.484046173892) | |||
24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
24750 | 24750 | 182725 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1734 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987217.2069 | 2103447.5916 | 37.7549283802803 | -122.487179505586 | (37.7549283802803, -122.487179505586) | |||
24861 | 24861 | 182367 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986186.5787 | 2104935.6262 | 37.758953963431 | -122.49085314669901 | (37.758953963431, -122.490853146699) | |||
24978 | 24978 | 70667 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009828.97228 | 2111081.0117200003 | 37.777180585152394 | -122.40952002252399 | (37.7771805851524, -122.409520022524) | ||
24995 | 24995 | 181628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1290 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988037.8386 | 2106538.091 | 37.7634618698416 | -122.48456824258498 | (37.7634618698416, -122.484568242585) | |||
24998 | 24998 | 238025 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997578.60338 | 2106127.58066 | 37.762885697531296 | -122.451540352327 | (37.7628856975313, -122.451540352327) | |||
25020 | 25020 | 182555 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986616.8854 | 2105696.0047 | 37.761066882292 | -122.489420874881 | (37.761066882292, -122.489420874881) | |||
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) | |||
25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
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) | |||
25716 | 25716 | 135893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001843.597519999 | 2121830.48703 | 37.806245186226505 | -122.437914052191 | (37.8062451862265, -122.437914052191) | ||||
25806 | 25806 | 214442 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991187.94391 | 2101152.05769 | 37.7488561836758 | -122.47328030175801 | (37.7488561836758, -122.473280301758) | |||
25957 | 25957 | 247414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 971 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001933.8006 | 2109433.5045 | 37.772211390909 | -122.436713922993 | (37.772211390909, -122.436713922993) | |||
25980 | 25980 | 143091 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 620 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009899.7854 | 2120236.6745 | 37.802323796980296 | -122.409921530777 | (37.8023237969803, -122.409921530777) | |||
26050 | 26050 | 110340 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 564 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x4 | 6005097.2691 | 2111307.8756 | 37.7775372317236 | -122.42590465122801 | (37.7775372317236, -122.425904651228) | |||
26149 | 26149 | 142789 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 625 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007523.6751 | 2113458.738 | 37.783579806807296 | -122.417663367701 | (37.7835798068073, -122.417663367701) | |||
26502 | 26502 | 196418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010052.79507 | 2110841.7577299997 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | |||
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) | |||
27000 | 27000 | 214389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992333.20147 | 2097526.08875 | 37.7389664461405 | -122.469056185189 | (37.7389664461405, -122.469056185189) | |||
27002 | 27002 | 181705 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | |||
27485 | 27485 | 139129 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1580 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003642.6576 | 2114125.3602 | 37.785191028716795 | -122.431137787396 | (37.7851910287168, -122.431137787396) | |||
27558 | 27558 | 141133 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1901 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002295.7325 | 2113639.3231 | 37.7837800762345 | -122.435762938134 | (37.7837800762345, -122.435762938134) | |||
27579 | 27579 | 237973 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 47 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005397.275719999 | 2103411.57149 | 37.7558728147995 | -122.42430507393601 | (37.7558728147995, -122.424305073936) | |||
27817 | 27817 | 141769 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1360 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003743.0385 | 2113357.1314 | 37.7830873528992 | -122.430735659623 | (37.7830873528992, -122.430735659623) | |||
28014 | 28014 | 138798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1827 Broderick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000492.2704 | 2114959.4269 | 37.7873021338531 | -122.44209701285101 | (37.7873021338531, -122.442097012851) | |||
28134 | 28134 | 218416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 206 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994263.50524 | 2100633.1916900002 | 37.747609115379 | -122.46260745978901 | (37.747609115379, -122.462607459789) | |||
28314 | 28314 | 183612 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2043 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5990030.8699 | 2101452.3062 | 37.7496135205134 | -122.477303359393 | (37.7496135205134, -122.477303359393) | |||
28653 | 28653 | 140315 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2112 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997699.8421 | 2109926.1659 | 37.7733225841329 | -122.45139501771901 | (37.7733225841329, -122.451395017719) | |||
28949 | 28949 | 238015 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.76466594869029 | -122.44459477575501 | (37.7646659486903, -122.444594775755) | |||
28974 | 28974 | 214439 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1569 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996912.71569 | 2105759.04962 | 37.7618356500092 | -122.453816799006 | (37.7618356500092, -122.453816799006) | |||
29045 | 29045 | 78786 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | ||
29059 | 29059 | 214419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 479 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5992969.97647 | 2090349.4269700001 | 37.7192978763685 | -122.466333093823 | (37.7192978763685, -122.466333093823) | |||
29296 | 29296 | 244956 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 298 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005155.9394 | 2109820.0209 | 37.77345526051 | -122.42559577205 | (37.77345526051, -122.42559577205) | |||
29658 | 29658 | 214395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994322.3379999995 | 2098681.3180299997 | 37.7422531489715 | -122.462262480723 | (37.7422531489715, -122.462262480723) | |||
30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
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) | |||
30442 | 30442 | 142001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 762 FULTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004249.2696 | 2111539.4607 | 37.7781251474871 | -122.42885467932301 | (37.7781251474871, -122.428854679323) | |||
30623 | 30623 | 182368 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986188.3183 | 2104920.5503 | 37.758912670790004 | -122.490846021107 | (37.75891267079, -122.490846021107) | |||
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) | |||
30952 | 30952 | 182628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1890 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988800.9853 | 2102469.1319999998 | 37.7523340169161 | -122.48163075760901 | (37.7523340169161, -122.481630757609) | |||
30963 | 30963 | 244972 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 209 Rose St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005534.5777 | 2109768.9686 | 37.7733364706745 | -122.424282374507 | (37.7733364706745, -122.424282374507) | |||
30964 | 30964 | 140965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 72 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997532.582 | 2113283.8483 | 37.7825323254485 | -122.45221591068399 | (37.7825323254485, -122.452215910684) | |||
32011 | 32011 | 245193 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 48 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000872.1204 | 2109220.0374 | 37.77156487066021 | -122.44037104524901 | (37.7715648706602, -122.440371045249) | |||
32147 | 32147 | 182060 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1363 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988012.4779 | 2106014.3806 | 37.7620224274243 | -122.48461753831002 | (37.7620224274243, -122.48461753831) | |||
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) | |||
32270 | 32270 | 183579 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2610 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988968.1029 | 2097542.0935 | 37.7388153818785 | -122.480692181856 | (37.7388153818785, -122.480692181856) | |||
32327 | 32327 | 182162 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1626 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988119.2271 | 2104209.3374 | 37.757072485353106 | -122.48411596268 | (37.7570724853531, -122.48411596268) | |||
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) | ||
32754 | 32754 | 138797 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1823 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000490.7856 | 2114966.8512 | 37.7873224344393 | -122.442102683059 | (37.7873224344393, -122.442102683059) | |||
32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
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) | |||
32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
33113 | 33113 | 183374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2725 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985535.6187 | 2096728.138 | 37.736380379394 | -122.492500010635 | (37.736380379394, -122.492500010635) | |||
33528 | 33528 | 182051 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1353 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988011.3956 | 2106063.6211 | 37.7621575653556 | -122.484624893587 | (37.7621575653556, -122.484624893587) | |||
33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
34928 | 34928 | 178912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993780.74611 | 2086770.03775 | 37.709516474781104 | -122.463270994886 | (37.7095164747811, -122.463270994886) | ||||
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) | ||||
35260 | 35260 | 135914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | |||
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) | |||
35596 | 35596 | 79919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 4 | 5988008.149 | 2106155.0675 | 37.762408463106496 | -122.484642830378 | (37.7624084631065, -122.484642830378) | ||
35621 | 35621 | 181328 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1749 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987757.6067 | 2098927.9954 | 37.742550273655 | -122.484979108902 | (37.742550273655, -122.484979108902) | |||
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) | |||
35756 | 35756 | 218355 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993521.424240001 | 2100014.7209799998 | 37.7458681870785 | -122.465128597612 | (37.7458681870785, -122.465128597612) |
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");