Street_Tree_List

Data source: data.sfgov.org

970 rows where qSpecies = 75 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
79565 84717 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
81310 84715 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
83280 84707 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
90707 84712 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
99232 84714 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
100997 84709 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
102510 84710 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
106675 84713 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
118894 84711 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
119296 84708 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
123620 84716 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2007 12:00:00 AM     Permit No. 49325 6001553.346940001 2108280.88879 37.7690249659747 -122.437947368595 (37.7690249659747, -122.437947368595)
36738 181277 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988402.74919 2089827.8491900002 37.7176011677477 -122.482081905481 (37.7176011677477, -122.482081905481)
156730 181275 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988424.04089 2089826.4329400002 37.7175985174299 -122.482008206935 (37.7175985174299, -122.482008206935)
168519 181276 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988413.87941 2089827.13064 37.7175998421416 -122.482043381217 (37.7175998421416, -122.482043381217)
153281 202068 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1 Hwy 101 S On Ramp 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6013001.93809 2090218.0162799999 37.7200725469917 -122.39708043181601 (37.7200725469917, -122.397080431816)
19459 15076 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1 Minerva St 2 Median : Cutout 11 Tree 1 DPW 2     6 11   5995952.59829 2089005.6317099999 37.7157797770894 -122.455926258705 (37.7157797770894, -122.455926258705)
21404 15067 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1 Minerva St 9 Median : Cutout 11 Tree 1 DPW 2     3 11   5996019.74584 2089003.9616 37.7157790450506 -122.455694046564 (37.7157790450506, -122.455694046564)
175604 203184 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 10 Arkansas St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6012812.5292 2106977.67983 37.766080486952795 -122.398910820196 (37.7660804869528, -122.398910820196)
186788 203185 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 10 Arkansas St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 4ft   6012813.13968 2106962.381 37.76603851379279 -122.398907634804 (37.7660385137928, -122.398907634804)
1514 243952 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007022.68787 2110044.22077 37.7741761624211 -122.41915431212601 (37.7741761624211, -122.419154312126)
1515 243950 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 13 Width 5ft Permit Number 47529 6007004.81099 2110130.42285 37.774411845966895 -122.419222267617 (37.7744118459669, -122.419222267617)
1516 243951 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 14 Width 5ft Permit Number 47529 6007014.66541 2110083.11128 37.774282494675795 -122.419184822535 (37.7742824946758, -122.419184822535)
1518 243948 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 11 Width 5ft Permit Number 47529 6006987.09759 2110205.04369 37.774615739356705 -122.41928883630399 (37.7746157393567, -122.419288836304)
1519 243949 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 12 Width 5ft Permit Number 47529 6006997.017419999 2110160.92453 37.7744951573695 -122.41925139124399 (37.7744951573695, -122.419251391244)
1521 243954 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007048.80869 2109949.46518 37.773917457170796 -122.41905723302 (37.7739174571708, -122.41905723302)
1533 243953 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 10 South Van Ness Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2004 12:00:00 AM 14 Width 5ft Permit Number 47529 6007037.92355 2109985.61989 37.7740161163944 -122.41909745161301 (37.7740161163944, -122.419097451613)
15166 102426 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 100 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010110.9527900005 2112392.33205 37.780796958746 -122.408637087058 (37.780796958746, -122.408637087058)
23492 202174 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 100 Kalmanovitz St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 2ft   6013138.83373 2093054.0318599998 37.7278672922301 -122.39680594795401 (37.7278672922301, -122.396805947954)
66362 202177 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 100 Kalmanovitz St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 2ft   6013132.229119999 2093003.70662 37.7277287417687 -122.396825253678 (37.7277287417687, -122.396825253678)
180281 202175 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 100 Kalmanovitz St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 2ft   6013138.4392099995 2093044.77183 37.7278418441173 -122.396806662905 (37.7278418441173, -122.396806662905)
186914 202176 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 100 Kalmanovitz St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 2ft   6013132.98284 2093010.28184 37.7277468379346 -122.396823108819 (37.7277468379346, -122.396823108819)
28377 48685 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 100 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2002 12:00:00 AM 22   Permit Number 45967 5995923.78548 2113769.63655 37.7837738786202 -122.45781677815 (37.7837738786202, -122.45781677815)
132921 199473 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1000 03rd St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   6015478.1467 2109531.70871 37.7732414619454 -122.389869319627 (37.7732414619454, -122.389869319627)
156279 199472 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1000 03rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6015475.23167 2109575.21201 37.7733607507341 -122.389882442542 (37.7733607507341, -122.389882442542)
163780 199471 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1000 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6015471.47006 2109635.49599 37.773526068606294 -122.389899666361 (37.7735260686063, -122.389899666361)
189141 199474 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1000 03rd St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6015480.23631 2109482.55519 37.7731066131226 -122.389858657266 (37.7731066131226, -122.389858657266)
17162 25069 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1000X Dolores St 12 Median : Cutout 11 Tree 1 DPW 2     90 20   6005114.64614 2102050.12648 37.752118640770995 -122.42518562892599 (37.752118640771, -122.425185628926)
17262 25065 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1000X Dolores St 8 Median : Cutout 11 Tree 1 DPW 2     40 20   6005108.04672 2102186.2977 37.7524921625065 -122.42521813940901 (37.7524921625065, -122.425218139409)
17966 25063 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1000X Dolores St 6 Median : Cutout 11 Tree 1 DPW 2     90 20   6005101.20924 2102268.05958 37.7527162753581 -122.42524760211501 (37.7527162753581, -122.425247602115)
18277 25059 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1000X Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     40 20   6005094.91106 2102418.8508099997 37.7531299572042 -122.425280111693 (37.7531299572042, -122.425280111693)
18812 25066 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1000X Dolores St 9 Median : Cutout 11 Tree 1 DPW 2     90 20   6005105.419480001 2102158.55982 37.7524158523077 -122.425225251269 (37.7524158523077, -122.425225251269)
20631 25060 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1000X Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     40 20   6005096.113419999 2102391.61943 37.7530552540956 -122.425274016077 (37.7530552540956, -122.425274016077)
80612 28634 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1001 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/2003 12:00:00 AM 25 5X5   5996752.18528 2091690.06821 37.7231964704228 -122.453356228535 (37.7231964704228, -122.453356228535)
105609 28635 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1001 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/2003 12:00:00 AM 21 5X5   5996764.463409999 2091686.23626 37.723186652559 -122.45331350914 (37.723186652559, -122.45331350914)
46987 102441 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1007X Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010078.92624 2112396.7113200002 37.7808071894337 -122.408748191999 (37.7808071894337, -122.408748191999)
38867 199498 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1008 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   6010028.2471900005 2112434.38373 37.780907790314394 -122.40892617503 (37.7809077903144, -122.40892617503)
62727 199499 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1008 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   6009970.38295 2112379.67473 37.7807543308744 -122.40912249520001 (37.7807543308744, -122.4091224952)
1634 199504 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342)
1642 199503 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.983080001 2111924.50305 37.7795342467397 -122.40725478770099 (37.7795342467397, -122.407254787701)
187703 187521 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 100x Mary Teresa St 1 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
13867 102421 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 101 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 4x4   6010161.06831 2112431.87946 37.780908353287394 -122.40846650275199 (37.7809083532874, -122.408466502752)
156009 102420 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 101 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6010175.35097 2112415.36622 37.780863811667295 -122.408415926663 (37.7808638116673, -122.408415926663)
49819 49090 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 101 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23   Permit Number 46240 6005000.86531 2092599.96167 37.7261641966181 -122.424906823795 (37.7261641966181, -122.424906823795)
188775 246732 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 101 Ripley St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 8ft   6008546.25114 2099104.34804 37.7442234529633 -122.41311030320101 (37.7442234529633, -122.413110303201)
44869 199502 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1012 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6010449.4105 2111969.43782 37.7796547406221 -122.40743636892 (37.7796547406221, -122.40743636892)
184866 199501 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1012 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6010462.04247 2111980.9380099997 37.7796870244685 -122.40739348023199 (37.7796870244685, -122.407393480232)
103153 101530 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1030 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 4x3   5995974.8 2090771.5 37.720629710016205 -122.455977107218 (37.7206297100162, -122.455977107218)
122621 101531 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1030 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 4x3   5995974.8 2090771.5 37.720629710016205 -122.455977107218 (37.7206297100162, -122.455977107218)
160890 217448 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1030 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5995947.80275 2090762.8814700001 37.72060449599329 -122.456069804902 (37.7206044959933, -122.456069804902)
43355 41527 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1038 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/2000 12:00:00 AM 19   Permit Number 42067 6018424.261969999 2095097.67116 37.7337714988594 -122.378675747684 (37.7337714988594, -122.378675747684)
181853 201499 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1038 Innes Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6018416.79538 2095102.4725900001 37.7337842710237 -122.37870189547701 (37.7337842710237, -122.378701895477)
51345 217449 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1038 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   5995950.204940001 2090812.4665700002 37.7207407828315 -122.45606508435101 (37.7207407828315, -122.456065084351)
28011 124342 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 105 Palm Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   5995870.42219 2113701.84259 37.7835846686773 -122.457996486135 (37.7835846686773, -122.457996486135)
29445 124343 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 105 Palm Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5995870.59128 2113726.09219 37.7836512613147 -122.457997656644 (37.7836512613147, -122.457997656644)
45244 124344 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 105 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   5995869.2461 2113758.79509 37.7837409774514 -122.458004677882 (37.7837409774514, -122.458004677882)
147475 124341 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 105 Palm Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   5995870.37991 2113683.65327 37.783534723234894 -122.45799531563699 (37.7835347232349, -122.457995315637)
39967 199470 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050 03rd St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 5ft   6015462.75637 2109791.03207 37.7739526530238 -122.38994067543001 (37.7739526530238, -122.38994067543)
66564 199468 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6015459.06425 2109878.23066 37.77419187628129 -122.38995953961799 (37.7741918762813, -122.389959539618)
77197 199469 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050 03rd St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 5ft   6015461.94108 2109832.83992 37.7740674029079 -122.389946416702 (37.7740674029079, -122.389946416702)
168704 199467 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6015455.2503 2109935.9180799997 37.774350061636795 -122.389976763437 (37.7743500616368, -122.389976763437)
95580 100555 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050X Natoma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6007651.0 2109542.0 37.7728325469688 -122.41694527260599 (37.7728325469688, -122.416945272606)
110334 100554 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050X Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6007651.0 2109542.0 37.7728325469688 -122.41694527260599 (37.7728325469688, -122.416945272606)
139272 51395 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1050X Natoma St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/13/2004 12:00:00 AM 12 3x3 Permit Number 47722 6007651.0 2109542.0 37.7728325469688 -122.41694527260599 (37.7728325469688, -122.416945272606)
119225 28631 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1051 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2003 12:00:00 AM 18 5x5   5996604.51775 2091735.3595900002 37.7233123645372 -122.45386995284099 (37.7233123645372, -122.453869952841)
139974 28632 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1051 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2003 12:00:00 AM 18 5X5   5996612.56003 2091733.27597 37.723307104505295 -122.453842001957 (37.7233071045053, -122.453842001957)
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)
108446 23052 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1065 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/16/1992 12:00:00 AM 15 4X4   6006449.25295 2103416.3322 37.7559452321174 -122.420667325317 (37.7559452321174, -122.420667325317)
189103 96941 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 108 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23     5995926.85193 2113670.95774 37.7835031091294 -122.457799026544 (37.7835031091294, -122.457799026544)
115534 23054 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1081 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/16/1992 12:00:00 AM 12 4X4   6006403.948580001 2103302.7071 37.7556306904017 -122.420815936586 (37.7556306904017, -122.420815936586)
185563 244862 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 109 Prospect Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006939.89705 2098843.30943 37.7434163905501 -122.418646232936 (37.7434163905501, -122.418646232936)
82761 28581 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2003 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
87014 28580 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2003 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
89453 28583 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/29/2007 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
102619 28582 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/2003 12:00:00 AM 18 4X4   5996838.9416251 2091728.3014296002 37.7233064222609 -122.453059088902 (37.7233064222609, -122.453059088902)
107366 101903 Property Tree 7 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 4 Front Yard : Yard 7 Tree 1 DPW 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
110616 101905 Property Tree 7 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 6 Front Yard : Yard 7 Tree 1 DPW 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
146191 101904 Property Tree 7 Washingtonia robusta :: Mexican Fan Palm 75 1100 Ocean Ave 5 Front Yard : Yard 7 Tree 1 DPW 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
128162 28610 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1107 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/29/2007 12:00:00 AM 18 5X5   5996451.82773 2091748.4966099998 37.7233396801105 -122.45439871889799 (37.7233396801105, -122.454398718898)
35169 217430 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   5991534.38297 2105188.62915 37.7599596057689 -122.47237655325 (37.7599596057689, -122.47237655325)
153758 217429 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   5991520.38705 2105187.01956 37.7599543762085 -122.472424840551 (37.7599543762085, -122.472424840551)
173091 217428 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991492.83801 2105186.64815 37.7599517618807 -122.47252009133601 (37.7599517618807, -122.472520091336)
66149 181268 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1116 Girard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6011841.7145 2089718.86782 37.7186373306372 -122.401055901109 (37.7186373306372, -122.401055901109)
117717 28609 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1117 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2003 12:00:00 AM 18 5X5   5996444.46775 2091779.60617 37.723424677500205 -122.454426406995 (37.7234246775002, -122.454426406995)
135412 137503 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1142 Filbert St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 3ft   6007446.543330001 2119552.3525099996 37.8003070257165 -122.418362418606 (37.8003070257165, -122.418362418606)
141877 28584 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1150 Ocean Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/2003 12:00:00 AM 18 3X3   5996037.5543 2091961.1786900002 37.72389988729329 -122.455846143025 (37.7238998872933, -122.455846143025)
119817 105068 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 117 PROSPECT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006924.9 2098775.6 37.743229631270104 -122.41869328836 (37.7432296312701, -122.41869328836)
27436 244863 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 117 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6006906.41702 2098789.62543 37.7432671013094 -122.418758192246 (37.7432671013094, -122.418758192246)
11231 16408 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1186X Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     42 TR   6001104.60764 2087178.31507 37.7110567247495 -122.43798776335 (37.7110567247495, -122.43798776335)
78467 115494 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1199X OCEAN AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
116577 106315 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1199X OCEAN AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 734.159ms · Data source: data.sfgov.org