Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
824 | 824 | 175557 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 80X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | Width 3ft | 5991341.18573 | 2088991.3817 | 37.71547490063521 | -122.471864234655 | (37.7154749006352, -122.471864234655) | ||
1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
1621 | 1621 | 88501 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1599 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51438 | 6015120.9647 | 2094333.0532 | 37.7314893544439 | -122.390042929541 | (37.7314893544439, -122.390042929541) | |
6342 | 6342 | 30510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | |
10426 | 10426 | 108779 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) |
10430 | 10430 | 86483 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1706 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987833.1754 | 2103641.2255 | 37.7554959453769 | -122.48506354557101 | (37.7554959453769, -122.485063545571) | ||
10488 | 10488 | 86479 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103389.1385 | 37.7548041785464 | -122.485021542908 | (37.7548041785464, -122.485021542908) | ||
10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
10877 | 10877 | 86480 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1742 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987841.1062 | 2103418.0293 | 37.754883570877105 | -122.485019744249 | (37.7548835708771, -122.485019744249) | ||
11268 | 11268 | 86482 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1722 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.8749 | 2103544.3561 | 37.7552300671815 | -122.48505056143499 | (37.7552300671815, -122.485050561435) | ||
11450 | 11450 | 86561 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1891 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102437.7427 | 37.7521908954775 | -122.485011502397 | (37.7521908954775, -122.485011502397) | ||
11831 | 11831 | 86477 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1754 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103364.7795 | 37.754737295309 | -122.485019755857 | (37.754737295309, -122.485019755857) | ||
12330 | 12330 | 108783 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.7554099998 | 37.7136477830893 | -122.42243082291901 | (37.7136477830893, -122.422430822919) |
15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
17785 | 17785 | 32763 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1754 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778589 | 6009301.89278 | 2099228.78566 | 37.7446075228294 | -122.410506232583 | (37.7446075228294, -122.410506232583) | |
18354 | 18354 | 29366 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X3 | 5992064.02141 | 2096527.0918599998 | 37.7362078962607 | -122.46991416090599 | (37.7362078962607, -122.469914160906) | ||
18576 | 18576 | 29362 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5991983.966469999 | 2096447.7248099998 | 37.7359853464519 | -122.470185163514 | (37.7359853464519, -122.470185163514) | ||
19218 | 19218 | 29363 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5992002.78104 | 2096471.37185 | 37.736051362971004 | -122.470121835975 | (37.736051362971, -122.470121835975) | ||
19222 | 19222 | 29357 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991847.829940001 | 2096308.81938 | 37.7355960757897 | -122.470645723443 | (37.7355960757897, -122.470645723443) | ||
19378 | 19378 | 27278 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005367.959369999 | 2108416.37045 | 37.7696131525447 | -122.424762488 | (37.7696131525447, -122.424762488) | |||
19384 | 19384 | 27275 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005306.02285 | 2108414.57657 | 37.7696047286145 | -122.424976596817 | (37.7696047286145, -122.424976596817) | |||
20563 | 20563 | 29361 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991939.73246 | 2096403.05712 | 37.735860142840096 | -122.470334844889 | (37.7358601428401, -122.470334844889) | ||
20795 | 20795 | 29365 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992050.3612 | 2096514.70328 | 37.7361730907045 | -122.46996048768601 | (37.7361730907045, -122.469960487686) | ||
20965 | 20965 | 29364 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992027.40322 | 2096494.06765 | 37.7361151033221 | -122.470038359996 | (37.7361151033221, -122.470038359996) | ||
21756 | 21756 | 29359 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991917.55406 | 2096377.82265 | 37.735789573027205 | -122.470409686474 | (37.7357895730272, -122.470409686474) | ||
22089 | 22089 | 29358 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991885.18 | 2096342.85411 | 37.735691686328295 | -122.470519069219 | (37.7356916863283, -122.470519069219) | ||
22167 | 22167 | 29360 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991958.47705 | 2096423.3893400002 | 37.73591705373521 | -122.470271518219 | (37.7359170537352, -122.470271518219) | ||
22191 | 22191 | 29356 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991811.277419999 | 2096273.10994 | 37.7354959129041 | -122.47076949802201 | (37.7354959129041, -122.470769498022) | ||
22943 | 22943 | 115613 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
22952 | 22952 | 115614 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
24588 | 24588 | 125698 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5999370.9628800005 | 2116081.41447 | 37.7903188519859 | -122.446057218191 | (37.7903188519859, -122.446057218191) | |||
28060 | 28060 | 204303 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2663 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990796.60271 | 2097278.2689900002 | 37.7381970923259 | -122.47435090236701 | (37.7381970923259, -122.474350902367) | |||
30708 | 30708 | 221176 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 398 Surrey St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001072.81046 | 2096163.63119 | 37.735726554821504 | -122.43874110741899 | (37.7357265548215, -122.438741107419) | |||
31054 | 31054 | 205576 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993987.58227 | 2096991.7389900002 | 37.737594705717896 | -122.463297378285 | (37.7375947057179, -122.463297378285) | |||
36453 | 36453 | 221122 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 8 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007401.99746 | 2099837.76455 | 37.7461729475405 | -122.41711885317 | (37.7461729475405, -122.41711885317) | |||
38652 | 38652 | 204326 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 201 Magellan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5995034.06083 | 2100651.9514 | 37.747704971418 | -122.45994430098699 | (37.747704971418, -122.459944300987) | |||
45990 | 45990 | 34666 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3047 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1997 12:00:00 AM | 3 | 5.5x6 | Permit Number 38514 | 6003371.82856 | 2118846.08663 | 37.7981375866326 | -122.432412059279 | (37.7981375866326, -122.432412059279) |
46153 | 46153 | 221125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 229 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6009787.17662 | 2099559.77195 | 37.745543532705604 | -122.408851557364 | (37.7455435327056, -122.408851557364) | |||
47076 | 47076 | 221171 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 11 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000910.085469999 | 2105681.05677 | 37.761849869193 | -122.43998592380501 | (37.761849869193, -122.439985923805) | |||
51488 | 51488 | 205597 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995496.70265 | 2099913.2188 | 37.7457031929561 | -122.45829106020001 | (37.7457031929561, -122.4582910602) | |||
51853 | 51853 | 204330 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5992106.1404800005 | 2096570.57144 | 37.73632971483521 | -122.46977170381099 | (37.7363297148352, -122.469771703811) | |||
54254 | 54254 | 204302 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2611 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990782.62363 | 2097592.59711 | 37.739059347010205 | -122.474422166453 | (37.7390593470102, -122.474422166453) | |||
60899 | 60899 | 175558 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1716 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006381.40886 | 2092046.2621799998 | 37.724721740686995 | -122.42009507583799 | (37.724721740687, -122.420095075838) | |||
61422 | 61422 | 175560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 105 Burrows St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6011176.06814 | 2093472.4733799999 | 37.728906802388394 | -122.403620739722 | (37.7289068023884, -122.403620739722) | ||||
64259 | 64259 | 185267 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2301 Vicente St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985773.8434 | 2097496.0598 | 37.7385028138514 | -122.491732893269 | (37.7385028138514, -122.491732893269) | |||
67242 | 67242 | 246811 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6010262.216659999 | 2098999.82172 | 37.7440326285028 | -122.40716947078998 | (37.7440326285028, -122.40716947079) | |||
67360 | 67360 | 141771 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1749 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002929.9391 | 2113383.5737 | 37.7831138570318 | -122.433550539983 | (37.7831138570318, -122.433550539983) | |||
73335 | 73335 | 204327 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 195 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5995043.41176 | 2100664.35113 | 37.747739555752204 | -122.459912864294 | (37.7477395557522, -122.459912864294) | |||
83020 | 83020 | 115619 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
85928 | 85928 | 87198 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3984 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2008 12:00:00 AM | 3 | 2.5x3 | Permit Number 50214 | 5995710.95001 | 2114863.89205 | 37.786766180939395 | -122.45863234603901 | (37.7867661809394, -122.458632346039) | |
89002 | 89002 | 119272 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1101 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 3x3 | 6009465.43944441 | 2117056.87897214 | 37.793568508665295 | -122.41119983681601 | (37.7935685086653, -122.411199836816) | ||
113972 | 113972 | 51581 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1639 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2005 12:00:00 AM | 3 | Permit Number 47874 | 6006611.817858701 | 2116483.82002415 | 37.791834582054896 | -122.421032908654 | (37.7918345820549, -122.421032908654) | ||
114945 | 114945 | 115618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
115370 | 115370 | 107863 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 218 HOWTH ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3 | 5997350.1 | 2090721.9 | 37.720572361158105 | -122.451219574954 | (37.7205723611581, -122.451219574954) | ||||
131982 | 131982 | 221172 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 11 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000923.42132 | 2105688.65448 | 37.7618714897953 | -122.43994034528 | (37.7618714897953, -122.43994034528) | |||
137831 | 137831 | 205575 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993984.55624 | 2097010.92185 | 37.7376472027498 | -122.46330923223101 | (37.7376472027498, -122.463309232231) | |||
138773 | 138773 | 205568 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 6 Locksley Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994301.6681 | 2105012.30737 | 37.7596352454884 | -122.462793133809 | (37.7596352454884, -122.462793133809) | |||
138893 | 138893 | 23604 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 200X Vasquez Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
144108 | 144108 | 86351 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 2423 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 10:30:00 AM | 3 | 3x3 | 5988571.076426 | 2098824.756846 | 37.7423141562535 | -122.482158841615 | (37.7423141562535, -122.482158841615) | ||
156456 | 156456 | 205596 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995525.67673 | 2099905.10703 | 37.745682584978205 | -122.458190285765 | (37.7456825849782, -122.458190285765) | |||
159852 | 159852 | 205589 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1939 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993443.93471 | 2102269.25213 | 37.752054085634704 | -122.46556030186501 | (37.7520540856347, -122.465560301865) | |||
162447 | 162447 | 204294 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2155 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991295.02228 | 2100740.61314 | 37.7477326633329 | -122.472880030596 | (37.7477326633329, -122.472880030596) | |||
162656 | 162656 | 204321 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 270 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992107.33741 | 2095082.2192 | 37.7322431424058 | -122.46965924719 | (37.7322431424058, -122.46965924719) | |||
167664 | 167664 | 205574 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993983.2221 | 2097029.04502 | 37.7376968876071 | -122.463315159687 | (37.7376968876071, -122.463315159687) | |||
169257 | 169257 | 125697 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000257.02708 | 2116105.09438 | 37.790434429256 | -122.44299320909599 | (37.790434429256, -122.442993209096) | |||
172622 | 172622 | 140385 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1745 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002953.8498 | 2113388.1282 | 37.7831277191493 | -122.433468144329 | (37.7831277191493, -122.433468144329) | |||
175542 | 175542 | 204231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1350 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5993984.50051 | 2106375.59757 | 37.7633602131233 | -122.463989011788 | (37.7633602131233, -122.463989011788) | |||
186023 | 186023 | 72370 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3 | 5990680.359209999 | 2111038.5537900003 | 37.7759724517855 | -122.475757373153 | (37.7759724517855, -122.475757373153) |
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");