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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
136903 | 136903 | 181233 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6011973.9880099995 | 2087758.6255 | 37.7132622770132 | -122.400461065249 | (37.7132622770132, -122.400461065249) | |||
139686 | 139686 | 1799 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | |||
141476 | 141476 | 1802 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
141864 | 141864 | 28413 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 530X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998569.7206668 | 2094722.0869743999 | 37.731625696446706 | -122.44729150596599 | (37.7316256964467, -122.447291505966) | ||
144221 | 144221 | 1803 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
145369 | 145369 | 6107 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
148069 | 148069 | 244856 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6009332.074580001 | 2100182.02874 | 37.747226610324205 | -122.410469167039 | (37.7472266103242, -122.410469167039) | |||
148463 | 148463 | 181230 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012037.58461 | 2087834.57577 | 37.713474367712294 | -122.400246583207 | (37.7134743677123, -122.400246583207) | |||
148566 | 148566 | 181253 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011090.2657 | 2087112.4680700002 | 37.7114387360727 | -122.403470098762 | (37.7114387360727, -122.403470098762) | |||
150822 | 150822 | 181256 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010998.20467 | 2086964.34233 | 37.7110268699605 | -122.40377787107799 | (37.7110268699605, -122.403777871078) | |||
153835 | 153835 | 217441 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 4ft | 5997030.67735 | 2094719.72249 | 37.731531141041295 | -122.45261208429 | (37.7315311410413, -122.45261208429) | |||
157229 | 157229 | 244857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Precita Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6009346.66532 | 2100208.95898 | 37.7473013727717 | -122.410420614427 | (37.7473013727717, -122.410420614427) | |||
159888 | 159888 | 181249 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011154.37999 | 2087216.41128 | 37.7117277242201 | -122.40325580920602 | (37.7117277242201, -122.403255809206) | |||
159892 | 159892 | 181232 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6011994.15316 | 2087783.96312 | 37.713332973598 | -122.400393145741 | (37.713332973598, -122.400393145741) | |||
160884 | 160884 | 217455 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 5996102.296490001 | 2089002.27895 | 37.7157791619582 | -122.455408593627 | (37.7157791619582, -122.455408593627) | |||
164681 | 164681 | 217438 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 4ft | 5997647.71271 | 2094708.73187 | 37.731536298642396 | -122.45047809200399 | (37.7315362986424, -122.450478092004) | |||
165812 | 165812 | 217459 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996291.57105 | 2089000.5851900002 | 37.715785369974796 | -122.45475425500099 | (37.7157853699748, -122.454754255001) | |||
165843 | 165843 | 181227 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012100.147000001 | 2087910.54687 | 37.713686457546395 | -122.400035676032 | (37.7136864575464, -122.400035676032) | |||
167542 | 167542 | 181237 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011709.60443 | 2087494.2224299998 | 37.712521531527294 | -122.40135630166 | (37.7125215315273, -122.40135630166) | |||
170196 | 170196 | 217458 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 5996270.87292 | 2089001.5829099999 | 37.7157869222056 | -122.454825868913 | (37.7157869222056, -122.454825868913) | |||
174465 | 174465 | 217456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996127.26791 | 2089002.03978 | 37.715779938072295 | -122.455322264126 | (37.7157799380723, -122.455322264126) | |||
174904 | 174904 | 217433 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 501x Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 4ft | 5998496.43118 | 2094696.04115 | 37.731549992634605 | -122.447543007012 | (37.7315499926346, -122.447543007012) | |||
175756 | 175756 | 181248 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011168.55226 | 2087238.084 | 37.7117880246642 | -122.403208349279 | (37.7117880246642, -122.403208349279) | |||
179057 | 179057 | 217462 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996487.36469 | 2088998.4739599999 | 37.7157908018916 | -122.454077353311 | (37.7157908018916, -122.454077353311) | |||
179815 | 179815 | 217437 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997794.81955 | 2094706.79322 | 37.7315393941054 | -122.449969377904 | (37.7315393941054, -122.449969377904) | |||
180976 | 180976 | 217454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996047.542640001 | 2089003.42322 | 37.7157791619486 | -122.45559792969601 | (37.7157791619486, -122.455597929696) | |||
183212 | 183212 | 181247 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011190.75371 | 2087265.8089 | 37.7118653915605 | -122.40313356348899 | (37.7118653915605, -122.403133563489) | |||
24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
40524 | 40524 | 246614 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6009136.11989 | 2100236.51166 | 37.7473652210349 | -122.411150613905 | (37.7473652210349, -122.411150613905) | |||
44429 | 44429 | 244865 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005730.73165 | 2096631.6868599998 | 37.737275621771104 | -122.42267009385401 | (37.7372756217711, -122.422670093854) | |||
48660 | 48660 | 243926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 6006689.91006 | 2103386.78803 | 37.7558776711221 | -122.41983295584299 | (37.7558776711221, -122.419832955843) | |||
66131 | 66131 | 244861 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 106 Chattanooga St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6004701.8654 | 2103001.6771 | 37.7547080488647 | -122.42668084266501 | (37.7547080488647, -122.426680842665) | |||
69642 | 69642 | 243914 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 569 Peralta Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 6009859.0295 | 2098846.17451 | 37.743588174566895 | -122.408552771098 | (37.7435881745669, -122.408552771098) | |||
76881 | 76881 | 243925 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006679.07286 | 2103590.73607 | 37.7564370548525 | -122.41988490606501 | (37.7564370548525, -122.419884906065) | |||
135845 | 135845 | 243924 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006678.4863599995 | 2103600.0339099998 | 37.7564625515326 | -122.419887594147 | (37.7564625515326, -122.419887594147) | |||
146999 | 146999 | 243913 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 569 Peralta Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6009859.67236 | 2098840.49646 | 37.743572619883 | -122.40855014778299 | (37.743572619883, -122.408550147783) | |||
156982 | 156982 | 137506 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 150 Francisco St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6010570.56702 | 2121351.03968 | 37.8054211392381 | -122.407678906174 | (37.8054211392381, -122.407678906174) | |||
161827 | 161827 | 203197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.39615821213499 | (37.7932554199655, -122.396158212135) | |||
165364 | 165364 | 203196 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 10ft | 6013792.252169999 | 2116838.17263 | 37.7932096975269 | -122.39621327133301 | (37.7932096975269, -122.396213271333) | |||
170054 | 170054 | 243935 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 293 Bemis St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6002891.579 | 2096165.14853 | 37.7358340238094 | -122.432453031508 | (37.7358340238094, -122.432453031508) | |||
183936 | 183936 | 244866 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 140 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6005707.387519999 | 2096634.20508 | 37.737281219162504 | -122.422750984277 | (37.7372812191625, -122.422750984277) | |||
24537 | 24537 | 217484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 554 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997767.10933 | 2095284.1068799999 | 37.7331229743458 | -122.450106772723 | (37.7331229743458, -122.450106772723) | ||||
25192 | 25192 | 203195 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012994.723999999 | 2096005.499 | 37.735963390387 | -122.39751105148999 | (37.735963390387, -122.39751105149) | ||||
25274 | 25274 | 203174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 331 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6014370.72377 | 2105559.7788 | 37.7622739427176 | -122.39342205628999 | (37.7622739427176, -122.39342205629) | |||
27544 | 27544 | 217486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 134 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 5999850.54516 | 2094099.6824900003 | 37.729989823555705 | -122.442818779256 | (37.7299898235557, -122.442818779256) | |||
28270 | 28270 | 217447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.00419 | 2091109.04775 | 37.721484434931796 | -122.460338956771 | (37.7214844349318, -122.460338956771) | |||
31642 | 31642 | 217485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 616 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998040.52965 | 2095018.98025 | 37.7324106420337 | -122.449142396404 | (37.7324106420337, -122.449142396404) | |||
32803 | 32803 | 243929 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1409 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6001410.85086 | 2099557.6127299997 | 37.745064858666 | -122.437815383076 | (37.745064858666, -122.437815383076) | |||
33282 | 33282 | 217464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | |||
33283 | 33283 | 181264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6009517.64457 | 2087677.5938400002 | 37.712902490626895 | -122.40894535574499 | (37.7129024906269, -122.408945355745) | |||
35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
37483 | 37483 | 217487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999757.91748 | 2093744.86936 | 37.729010308071 | -122.44311353116501 | (37.729010308071, -122.443113531165) | |||
38493 | 38493 | 181278 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003332.53306 | 2094181.6518 | 37.730412786411904 | -122.430786976247 | (37.7304127864119, -122.430786976247) | |||
39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
41733 | 41733 | 203194 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012994.12431 | 2096000.54159 | 37.7359497449792 | -122.3975127773 | (37.7359497449792, -122.3975127773) | ||||
43297 | 43297 | 181269 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | |||
44370 | 44370 | 137500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997635.71873 | 2114163.76026 | 37.78495423950061 | -122.451922604659 | (37.7849542395006, -122.451922604659) | |||
44785 | 44785 | 243930 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1351 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6001401.88208 | 2099729.52286 | 37.7455363732181 | -122.437858706116 | (37.7455363732181, -122.437858706116) | |||
47898 | 47898 | 248076 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Holladay Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6010319.424219999 | 2098700.6468 | 37.7432143605434 | -122.40695057673099 | (37.7432143605434, -122.406950576731) | |||
51670 | 51670 | 181284 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 75 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6006132.8407 | 2093885.45886 | 37.7297577652023 | -122.421084877777 | (37.7297577652023, -122.421084877777) | ||||
51719 | 51719 | 203192 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2701 Phelps St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6011784.79678 | 2093250.5774700001 | 37.728331506992895 | -122.40150072019699 | (37.7283315069929, -122.401500720197) | |||
54238 | 54238 | 181285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 55 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6006176.18741 | 2094039.87064 | 37.7301841895453 | -122.420945981966 | (37.7301841895453, -122.420945981966) | ||||
55931 | 55931 | 181279 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 164 Otsego Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000580.61226 | 2092352.75488 | 37.725234756259105 | -122.440169631943 | (37.7252347562591, -122.440169631943) | ||||
59707 | 59707 | 243931 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6001427.70796 | 2099722.90348 | 37.7455196665071 | -122.437768930406 | (37.7455196665071, -122.437768930406) | |||
61157 | 61157 | 243933 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001410.80109 | 2099722.64145 | 37.7455179856652 | -122.437827372845 | (37.7455179856652, -122.437827372845) | |||
62711 | 62711 | 203188 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2212 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 6012161.98551 | 2101908.2137 | 37.752124581703896 | -122.400804745651 | (37.7521245817039, -122.400804745651) | |||
67120 | 67120 | 217465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 270 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991973.319019999 | 2090312.5132 | 37.719138962561395 | -122.469775446797 | (37.7191389625614, -122.469775446797) | |||
67886 | 67886 | 181273 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 5993253.89248 | 2087254.87445 | 37.710817354905295 | -122.465127066954 | (37.7108173549053, -122.465127066954) | |||
70487 | 70487 | 217481 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999774.01899 | 2095479.90508 | 37.7337752292392 | -122.443182429144 | (37.7337752292392, -122.443182429144) | |||
72671 | 72671 | 217483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 487 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998873.28001 | 2094951.91453 | 37.7322740898789 | -122.44625857187599 | (37.7322740898789, -122.446258571876) | |||
76143 | 76143 | 217453 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 296 Montana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994116.14589 | 2089356.42812 | 37.7166374065639 | -122.462299264809 | (37.7166374065639, -122.462299264809) | |||
116440 | 116440 | 187523 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012557.25141 | 2087947.38565 | 37.713813084777605 | -122.39845832991199 | (37.7138130847776, -122.398458329912) | ||||
130191 | 130191 | 217445 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5994721.42442 | 2091190.6109200001 | 37.721708469553 | -122.46033995415199 | (37.721708469553, -122.460339954152) | |||
130520 | 130520 | 181272 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4061 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5991602.94551 | 2088924.16966 | 37.7153054953149 | -122.47095459108299 | (37.7153054953149, -122.470954591083) | |||
137010 | 137010 | 244855 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 899 Hampshire St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010216.96114 | 2104085.25819 | 37.7579935807494 | -122.407684453192 | (37.7579935807494, -122.407684453192) | |||
137624 | 137624 | 217466 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 380 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5992234.1227 | 2090402.1103 | 37.7194000456453 | -122.46888047296801 | (37.7194000456453, -122.468880472968) | |||
137678 | 137678 | 244821 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005757.946719999 | 2100569.56041 | 37.748089667204205 | -122.422855781374 | (37.7480896672042, -122.422855781374) | |||
137725 | 137725 | 217829 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Ocean Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991671.86156 | 2094594.4240599999 | 37.7308786001697 | -122.471129246615 | (37.7308786001697, -122.471129246615) | ||||
137787 | 137787 | 217451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 248 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5994521.5845800005 | 2089667.4223099998 | 37.7175146601568 | -122.460920402674 | (37.7175146601568, -122.460920402674) | ||||
138237 | 138237 | 217446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.49228 | 2091159.88936 | 37.7216240618899 | -122.46034095147101 | (37.7216240618899, -122.460340951471) | |||
146688 | 146688 | 244823 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005752.797 | 2100569.1543099997 | 37.74808826157621 | -122.422873560084 | (37.7480882615762, -122.422873560084) | |||
147181 | 147181 | 243932 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001413.8789800005 | 2099722.88395 | 37.745518826532 | -122.43781674736799 | (37.745518826532, -122.437816747368) | |||
147977 | 147977 | 181274 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 328 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 5993286.62087 | 2087254.83892 | 37.7108191445702 | -122.46501394844 | (37.7108191445702, -122.46501394844) | |||
149948 | 149948 | 181283 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 221 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6004356.32803 | 2092093.79207 | 37.72473793927671 | -122.427098916803 | (37.7247379392767, -122.427098916803) | ||||
150487 | 150487 | 217444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Holloway Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994706.40918 | 2091208.56862 | 37.721756913341295 | -122.46039315802601 | (37.7217569133413, -122.460393158026) | |||
151854 | 151854 | 217482 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 19 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999956.53878 | 2095464.0242299999 | 37.7337420298675 | -122.442550265996 | (37.7337420298675, -122.442550265996) | |||
153688 | 153688 | 217480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5999643.16837 | 2095215.32408 | 37.7330412898258 | -122.44361581691099 | (37.7330412898258, -122.443615816911) | |||
155650 | 155650 | 181265 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6009530.324580001 | 2087672.9738099999 | 37.7128905152502 | -122.40890120353201 | (37.7128905152502, -122.408901203532) | |||
156217 | 156217 | 181280 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6004524.91871 | 2092988.1896099998 | 37.727203289497794 | -122.42657977773999 | (37.7272032894978, -122.42657977774) | |||
156331 | 156331 | 202029 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1331 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6013954.19623 | 2091006.8516900002 | 37.7222914964254 | -122.39384396154199 | (37.7222914964254, -122.393843961542) | |||
156998 | 156998 | 181281 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6004496.25142 | 2093004.99255 | 37.727247805938795 | -122.426680076425 | (37.7272478059388, -122.426680076425) | |||
158497 | 158497 | 181270 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6011335.815769999 | 2088522.23161 | 37.715323375648296 | -122.40272048866899 | (37.7153233756483, -122.402720488669) | |||
159602 | 159602 | 244820 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005758.41375 | 2100573.51884 | 37.748100562499204 | -122.422854447683 | (37.7481005624992, -122.422854447683) | |||
165317 | 165317 | 217452 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 248 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5994521.8342699995 | 2089659.5838400002 | 37.7174931519523 | -122.46091897182801 | (37.7174931519523, -122.460918971828) | ||||
168723 | 168723 | 217830 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991664.0561 | 2094598.0007200001 | 37.730887969306 | -122.471156491586 | (37.730887969306, -122.471156491586) | ||||
169617 | 169617 | 244822 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005751.99744 | 2100574.03456 | 37.7481016165112 | -122.42287667172899 | (37.7481016165112, -122.422876671729) | |||
170710 | 170710 | 247119 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2301 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6002742.76916 | 2098847.9819 | 37.7431920249995 | -122.43315915579201 | (37.7431920249995, -122.433159155792) | ||||
171385 | 171385 | 244815 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 451 Florida St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 9ft | 6009251.4171400005 | 2106274.41145 | 37.7639503995181 | -122.411178363391 | (37.7639503995181, -122.411178363391) | |||
173440 | 173440 | 247055 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 500 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6002656.51125 | 2099493.5306599997 | 37.7449596577675 | -122.433503535865 | (37.7449596577675, -122.433503535865) | ||||
175090 | 175090 | 187522 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 65 Megan Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6012564.1625 | 2087957.56317 | 37.713841415230604 | -122.398435156171 | (37.7138414152306, -122.398435156171) |
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");