Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");