Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10638 | 10638 | 96234 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/15/2011 12:00:00 AM | Permit Number 767856 | ||||||||||
| 11641 | 11641 | 96232 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 16044 | 16044 | 96231 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 25407 | 25407 | 95032 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6004772.0 | 2093802.0 | 37.729451797878205 | -122.425783519869 | (37.7294517978782, -122.425783519869) | |||||||
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 79432 | 79432 | 106576 | Private 5 | Private shrub :: Private Shrub 64 | 507 STEINER ST | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | |||||
| 79753 | 79753 | 107409 | Undocumented 2 | Shrub :: Shrub 98 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5999028.2 | 2104385.8 | 37.758186107000796 | -122.44640141076401 | (37.7581861070008, -122.446401410764) | |||||
| 80534 | 80534 | 96292 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 83840 | 83840 | 107144 | Undocumented 2 | :: 54 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6015708.0 | 2115219.0 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | |||||
| 86139 | 86139 | 89139 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 87925 | 87925 | 104864 | Permitted Site 1 | :: 54 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000629.3 | 2102650.0 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | ||||||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
| 91008 | 91008 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10 | 5992930.0 | 2110298.0 | 37.77406925887279 | -122.467921468059 | (37.7740692588728, -122.467921468059) | ||||
| 92510 | 92510 | 88654 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 92559 | 92559 | 92776 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 94304 | 94304 | 94961 | Permitted Site 1 | Tree(s) :: 17 | 3098 PACIFIC AVE | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/25/2010 12:00:00 AM | 5999362.0 | 2116697.0 | 37.792008575714 | -122.446132526841 | (37.792008575714, -122.446132526841) | ||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 97106 | 97106 | 102276 | Private 5 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||||||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
| 99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 100274 | 100274 | 99610 | Undocumented 2 | Tree(s) :: 17 | 111 Corwin St | Unaccepted Street : Yard 14 | Landscaping 2 | Private 1 | 6000616.0 | 2104331.0 | 37.7581261988062 | -122.44090619353999 | (37.7581261988062, -122.44090619354) | ||||||
| 100486 | 100486 | 103619 | Undocumented 2 | Tree(s) :: 17 | 1200 Monterey Blvd | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 5994284.3 | 2094292.0 | 37.7301989768893 | -122.46207576474701 | (37.7301989768893, -122.462075764747) | |||||
| 100936 | 100936 | 96291 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 101229 | 101229 | 85273 | Permitted Site 1 | Tree(s) :: 17 | 36 Santa Cruz Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5993017.1 | 2086630.8 | 37.709090137513 | -122.465900153218 | (37.709090137513, -122.465900153218) | ||||||
| 101836 | 101836 | 92072 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 3001 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/18/2009 12:00:00 AM | Permit Number 52188 | 5999733.7 | 2116663.4 | 37.791937538515604 | -122.444844029888 | (37.7919375385156, -122.444844029888) | ||||
| 101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
| 102839 | 102839 | 102414 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1301 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000345.0 | 2109213.0 | 37.77151552050871 | -122.44219387377399 | (37.7715155205087, -122.442193873774) | |||||
| 103907 | 103907 | 106639 | Private 5 | Private shrub :: Private Shrub 64 | 1321X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2105100.0 | 37.7601403710114 | -122.44686158716699 | (37.7601403710114, -122.446861587167) | |||||
| 104353 | 104353 | 98250 | Permitted Site 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | |||||
| 105108 | 105108 | 104859 | Permitted Site 1 | :: 54 | 650 Fillmore St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.43103844044701 | (37.775386259915, -122.431038440447) | ||||||
| 105398 | 105398 | 117608 | Permitted Site 1 | :: 54 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 6005708.4 | 2111040.6 | 37.776837876057 | -122.423771533631 | (37.776837876057, -122.423771533631) | |||
| 105459 | 105459 | 96289 | Permitted Site 1 | Tree(s) :: 17 | 228 30th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Permit Number 767877 | 6005120.0 | 2098458.0 | 37.7422557889482 | -122.42491157296699 | (37.7422557889482, -122.424911572967) | |||||
| 109480 | 109480 | 92778 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 110838 | 110838 | 107348 | Private 5 | Private shrub :: Private Shrub 64 | 260 LANSDALE AVE | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5995019.0 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | |||||
| 110904 | 110904 | 109242 | Property Tree 7 | Private shrub :: Private Shrub 64 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | ||||||
| 110920 | 110920 | 85195 | Permitted Site 1 | Tree(s) :: 17 | 333 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5990168.0 | 2094689.0 | 37.731051182582604 | -122.47633519175501 | (37.7310511825826, -122.476335191755) | ||||||
| 111084 | 111084 | 89138 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 112497 | 112497 | 104858 | Permitted Site 1 | :: 54 | 4205 24th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6001816.0 | 2101720.7 | 37.7510272133613 | -122.43656924920201 | (37.7510272133613, -122.436569249202) | ||||||
| 113495 | 113495 | 92775 | Permitted Site 1 | Tree(s) :: 17 | 2701 Pacific Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 114285 | 114285 | 96183 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||||
| 114741 | 114741 | 104860 | Permitted Site 1 | :: 54 | 283 Randall St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | ||||||
| 115357 | 115357 | 98501 | Property Tree 7 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998998.0 | 2100740.0 | 37.748173910048706 | -122.446243600021 | (37.7481739100487, -122.446243600021) | ||||||
| 117077 | 117077 | 89137 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
| 119565 | 119565 | 99732 | Undocumented 2 | Shrub :: Shrub 98 | 4150 Ocean Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5986619.2 | 2095203.6 | 37.7322576937009 | -122.48864164528798 | (37.7322576937009, -122.488641645288) | |||||
| 119638 | 119638 | 109607 | Private 5 | Shrub :: Shrub 98 | 775 Congo St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.44111470541901 | (37.7350943222142, -122.441114705419) | |||||
| 120169 | 120169 | 104564 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 120372 | 120372 | 88656 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 122339 | 122339 | 104861 | Permitted Site 1 | :: 54 | 3458A 18th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6006508.0 | 2105569.9 | 37.7618617394874 | -122.42061702780899 | (37.7618617394874, -122.420617027809) | ||||||
| 123904 | 123904 | 106641 | Private 5 | Private shrub :: Private Shrub 64 | 1323X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 125761 | 125761 | 108576 | Property Tree 7 | :: 54 | 2479 Diamond St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6002240.0 | 2097369.0 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | |||||
| 125875 | 125875 | 89140 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 129188 | 129188 | 105003 | Undocumented 2 | Shrub :: Shrub 98 | 607 CONGO ST | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 6000094.1 | 2095817.0 | 37.73471905904071 | -122.44210000591002 | (37.7347190590407, -122.44210000591) | ||||||
| 138475 | 138475 | 96182 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||
| 138621 | 138621 | 104565 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 139298 | 139298 | 92611 | Permitted Site 1 | Shrub :: Shrub 98 | 3856 23rd St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 08/31/2009 12:00:00 AM | Permit Number 52924 | 6004067.0 | 2102488.0 | 37.753261698893496 | -122.428839761175 | (37.7532616988935, -122.428839761175) | ||||
| 140567 | 140567 | 94962 | Permitted Site 1 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/25/2010 12:00:00 AM | 5999362.0 | 2116697.3 | 37.7920093994348 | -122.44613254842899 | (37.7920093994348, -122.446132548429) | |||||
| 145716 | 145716 | 98878 | Property Tree 7 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998029.0 | 2100213.0 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | ||||||
| 84402 | 84402 | 109353 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 104832 | 104832 | 109350 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 113379 | 113379 | 109349 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 122284 | 122284 | 109352 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 125736 | 125736 | 109351 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 139898 | 139898 | 109348 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 96541 | 96541 | 110246 | Permitted Site 1 | :: 54 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.755484875136204 | -122.486075162345 | (37.7554848751362, -122.486075162345) | ||
| 20483 | 20483 | 109769 | Permitted Site 1 | :: 54 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 106864 | 106864 | 109768 | Permitted Site 1 | :: 54 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 88689 | 88689 | 109762 | Permitted Site 1 | :: 54 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 97786 | 97786 | 109767 | Permitted Site 1 | :: 54 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 101338 | 101338 | 110613 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 12.8x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
| 85779 | 85779 | 110615 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 89308 | 89308 | 103623 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.787503918723395 | -122.48671414227199 | (37.7875039187234, -122.486714142272) | ||
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 10101 | 10101 | 173846 | Permitted Site 1 | :: 54 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 118218 | 118218 | 104635 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 141674 | 141674 | 104634 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 143329 | 143329 | 93161 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 143915 | 143915 | 93160 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 88984 | 88984 | 109756 | Permitted Site 1 | :: 54 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 118010 | 118010 | 109755 | Permitted Site 1 | :: 54 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 121197 | 121197 | 109754 | Permitted Site 1 | :: 54 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) |
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");