Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2577 | 2577 | 42596 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1950 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42667 | 6005477.78345 | 2116550.81967 | 37.791954555107296 | -122.424961440544 | (37.7919545551073, -122.424961440544) | |
| 4364 | 4364 | 180633 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 500 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:31:00 AM | 3 | Width 6ft | 6002463.83622 | 2087495.3970299999 | 37.7120045661395 | -122.43331258910601 | (37.7120045661395, -122.433312589106) | ||
| 4546 | 4546 | 7946 | Landmark tree 9 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1701 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005703.15328 | 2116043.32965 | 37.7905738421571 | -122.424145551273 | (37.7905738421571, -122.424145551273) | |||
| 4734 | 4734 | 181032 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 51 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2017 12:14:00 PM | 3 | Width 4ft | 6000613.84351 | 2088248.98957 | 37.7139686369286 | -122.439760670618 | (37.7139686369286, -122.439760670618) | ||
| 5404 | 5404 | 9925 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2010 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6005193.66561 | 2116589.4202799997 | 37.7920444900059 | -122.425947239584 | (37.7920444900059, -122.425947239584) | ||
| 10658 | 10658 | 75132 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6002992.1034699995 | 2092540.72564 | 37.725887878997504 | -122.431846767938 | (37.7258878789975, -122.431846767938) | |
| 11029 | 11029 | 67936 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 78 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31649 | |||||||
| 11524 | 11524 | 78382 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 606 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2000 12:00:00 AM | 12 | 6001696.66297 | 2089972.42102 | 37.7187623714737 | -122.436141300492 | (37.7187623714737, -122.436141300492) | |||
| 12293 | 12293 | 75309 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | |
| 13878 | 13878 | 5809 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 25 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1998 12:00:00 AM | 6 | 3X4 | 6016112.32175 | 2096327.0001 | 37.737019264618205 | -122.386754585178 | (37.7370192646182, -122.386754585178) | ||
| 15049 | 15049 | 25930 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1940 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2008 12:00:00 AM | 12 | 3x3 | 6013172.33562 | 2096908.97422 | 37.7384540331375 | -122.396960298598 | (37.7384540331375, -122.396960298598) | ||
| 19732 | 19732 | 121049 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2650 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006281.0 | 2119745.0 | 37.800770307215295 | -122.42240936075501 | (37.8007703072153, -122.422409360755) | ||||
| 24950 | 24950 | 43688 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 219 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 4 | Permit Number 43332 | 5993346.74324 | 2114008.67547 | 37.7842818271711 | -122.466749684627 | (37.7842818271711, -122.466749684627) | |
| 25022 | 25022 | 231947 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.73712794050989 | -122.42510507394199 | (37.7371279405099, -122.425105073942) | |||
| 29060 | 29060 | 231980 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 48 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002629.60405 | 2105594.78534 | 37.7617107251998 | -122.43403262951401 | (37.7617107251998, -122.434032629514) | |||
| 30988 | 30988 | 35845 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 478 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 14 | Permit Number 39072 | 6001935.45212 | 2090855.28224 | 37.7212000747131 | -122.435379022551 | (37.7212000747131, -122.435379022551) | |
| 32655 | 32655 | 42595 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1950 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 5 | Permit Number 42667 | 6005494.51102 | 2116553.24353 | 37.7919621552701 | -122.42490373552499 | (37.7919621552701, -122.424903735525) | |
| 32685 | 32685 | 193531 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 200 Jennings St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6018621.46299 | 2096962.90365 | 37.7389039297614 | -122.37812339217399 | (37.7389039297614, -122.378123392174) | |||
| 33307 | 33307 | 231949 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007831.76681 | 2105714.97927 | 37.7623346100862 | -122.416048903649 | (37.7623346100862, -122.416048903649) | |||
| 35030 | 35030 | 231981 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 91 Clover Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6000469.665569999 | 2104934.36895 | 37.759774566664206 | -122.441455575241 | (37.7597745666642, -122.441455575241) | |||
| 35123 | 35123 | 231962 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 500 Andover St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007543.01124 | 2097062.2707 | 37.7385599903583 | -122.416434682233 | (37.7385599903583, -122.416434682233) | |||
| 35847 | 35847 | 78255 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 512 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6001977.4626400005 | 2090420.81734 | 37.7200095171006 | -122.43520274461599 | (37.7200095171006, -122.435202744616) | ||
| 37391 | 37391 | 56456 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 141 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1992 12:00:00 AM | Permit Number 30464 | 5999359.80887308 | 2107414.28954328 | 37.7665205189943 | -122.445472331181 | (37.7665205189943, -122.445472331181) | ||
| 37963 | 37963 | 231969 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 78 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004355.63348 | 2095669.80517 | 37.734556834538104 | -122.427355942145 | (37.7345568345381, -122.427355942145) | |||
| 38737 | 38737 | 231946 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 301 Webster St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004139.43859 | 2109828.9539900003 | 37.7734222994207 | -122.42911263196699 | (37.7734222994207, -122.429112631967) | |||
| 38892 | 38892 | 87046 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 735@ 8th Ave 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53657 | 5993787.03862 | 2110396.38433 | 37.7743888494182 | -122.464963993756 | (37.7743888494182, -122.464963993756) | |
| 39005 | 39005 | 231948 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 365 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6007200.80171 | 2096289.89745 | 37.736419973489106 | -122.41756315512801 | (37.7364199734891, -122.417563155128) | |||
| 39472 | 39472 | 131189 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2501 Jackson St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002000.17825 | 2116671.28438 | 37.792088271701004 | -122.43700258209999 | (37.792088271701, -122.4370025821) | |||
| 40053 | 40053 | 231964 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 332 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008801.63861 | 2097226.11377 | 37.7390805674202 | -122.41209451265199 | (37.7390805674202, -122.412094512652) | |||
| 42335 | 42335 | 95809 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 691 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767553 | 6015468.0632 | 2105845.9769099997 | 37.7631206885995 | -122.389646729328 | (37.7631206885995, -122.389646729328) |
| 44463 | 44463 | 231953 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 195 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006489.5205 | 2105029.8668299997 | 37.7603778930513 | -122.420642603769 | (37.7603778930513, -122.420642603769) | |||
| 47855 | 47855 | 47495 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 222 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 10 | Permit Number 45388 | 6001706.9707 | 2093841.21109 | 37.7293857804089 | -122.436382409642 | (37.7293857804089, -122.436382409642) | |
| 48268 | 48268 | 231972 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 206 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003745.92075 | 2101014.04618 | 37.7491963890986 | -122.42984499216101 | (37.7491963890986, -122.429844992161) | |||
| 48684 | 48684 | 231974 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004099.54085 | 2102284.63466 | 37.7527051471301 | -122.428712732201 | (37.7527051471301, -122.428712732201) | |||
| 49091 | 49091 | 231963 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 500 Andover St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007553.143080001 | 2097114.00894 | 37.7387026219233 | -122.416403314785 | (37.7387026219233, -122.416403314785) | |||
| 49325 | 49325 | 231971 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 4098 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6002611.76959 | 2101830.0379 | 37.7513726180492 | -122.433825215284 | (37.7513726180492, -122.433825215284) | |||
| 49731 | 49731 | 49821 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1600X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012834.79813 | 2105677.969 | 37.762513010380395 | -122.39874257500799 | (37.7625130103804, -122.398742575008) | ||
| 49807 | 49807 | 231961 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 500 Andover St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007544.54493 | 2097042.2354599999 | 37.7385050642556 | -122.41642796070101 | (37.7385050642556, -122.416427960701) | |||
| 50000 | 50000 | 177525 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 100 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006897.82744 | 2093555.3740299998 | 37.728894518558604 | -122.418416832071 | (37.7288945185586, -122.418416832071) | |||
| 50495 | 50495 | 67516 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 327 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31052 | 5997915.17390153 | 2093778.82856929 | 37.728998308864604 | -122.449486452558 | (37.7289983088646, -122.449486452558) | ||
| 51636 | 51636 | 87042 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 735 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993785.1728 | 2110455.01638 | 37.7745497297907 | -122.464974707047 | (37.7745497297907, -122.464974707047) | |
| 54184 | 54184 | 177524 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 151 London St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002754.066980001 | 2092583.5778400002 | 37.725992044773 | -122.43267270259899 | (37.725992044773, -122.432672702599) | |||
| 55924 | 55924 | 49825 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1600X 18th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012763.71929 | 2105674.81061 | 37.7625003776121 | -122.39898819067899 | (37.7625003776121, -122.398988190679) | ||
| 57939 | 57939 | 231976 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 3670 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003921.45543 | 2103072.93083 | 37.7548595423439 | -122.42938479288999 | (37.7548595423439, -122.42938479289) | |||
| 58184 | 58184 | 46820 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 470 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 10 | Permit Number 44898 | 6003678.479180001 | 2090585.52708 | 37.720558222259704 | -122.42933465298701 | (37.7205582222597, -122.429334652987) | |
| 58265 | 58265 | 67227 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 807 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30686 | 5983524.12809 | 2110277.94013 | 37.7734665377075 | -122.50045600034201 | (37.7734665377075, -122.500456000342) | |
| 59837 | 59837 | 59096 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 735 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993787.7809 | 2110375.019 | 37.7743302287246 | -122.464959874093 | (37.7743302287246, -122.464959874093) | |
| 60617 | 60617 | 70028 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 555 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/11/1992 12:00:00 AM | 5 | 5983452.32231 | 2112030.7596400003 | 37.7782750565666 | -122.500834032057 | (37.7782750565666, -122.500834032057) | ||
| 62730 | 62730 | 63777 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 118 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24458 | 6004354.061629901 | 2101637.06942721 | 37.7509414857928 | -122.427786417218 | (37.7509414857928, -122.427786417218) | ||
| 64934 | 64934 | 49819 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1600X 18th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012718.30127 | 2105671.3018900002 | 37.762488212473706 | -122.39914502972 | (37.7624882124737, -122.39914502972) | ||
| 65460 | 65460 | 67249 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 559 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 5 | Permit Number 30713 | 5983459.33471 | 2112007.07812 | 37.778210445714706 | -122.500808022251 | (37.7782104457147, -122.500808022251) | |
| 66848 | 66848 | 43138 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1 Gambier St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005709.81909 | 2093489.2094299998 | 37.7286458955884 | -122.422519166951 | (37.7286458955884, -122.422519166951) | ||
| 70679 | 70679 | 231965 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 711 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6007531.06073 | 2097759.54123 | 37.7404738690811 | -122.416525379751 | (37.7404738690811, -122.416525379751) | |||
| 72109 | 72109 | 87043 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 735 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993784.66357 | 2110476.13962 | 37.7746076992047 | -122.464978002989 | (37.7746076992047, -122.464978002989) | |
| 72253 | 72253 | 209295 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2559 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992040.53101 | 2098014.3866 | 37.740290273365105 | -122.470103641773 | (37.7402902733651, -122.470103641773) | |||
| 72622 | 72622 | 231968 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 177 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004880.9264 | 2095958.67753 | 37.735379707894 | -122.425560380023 | (37.735379707894, -122.425560380023) | |||
| 75096 | 75096 | 231950 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 703 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007343.45792 | 2103120.9197299997 | 37.7551844539259 | -122.41755392628401 | (37.7551844539259, -122.417553926284) | |||
| 75746 | 75746 | 47753 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 70 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | Permit Number 45532 | 6000951.94406001 | 2101308.28424915 | 37.7498456794841 | -122.439527672975 | (37.7498456794841, -122.439527672975) | ||
| 76386 | 76386 | 43141 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 45 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 10 | Permit Number 42954 | 6005755.191330001 | 2093338.41647 | 37.7282344107702 | -122.422351602551 | (37.7282344107702, -122.422351602551) | |
| 77031 | 77031 | 46851 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 440 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44919 | 6003321.97716 | 2091035.01696 | 37.7217722323726 | -122.430599024221 | (37.7217722323726, -122.430599024221) | |
| 77402 | 77402 | 66407 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29534 | 6008039.98859373 | 2096389.06187115 | 37.736739441844705 | -122.414668739511 | (37.7367394418447, -122.414668739511) | ||
| 78950 | 78950 | 64810 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 718 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25813 | 6001878.33374757 | 2099742.03375236 | 37.745597806818104 | -122.436212108036 | (37.7455978068181, -122.436212108036) | ||
| 79658 | 79658 | 60181 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 45 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1982 12:00:00 AM | Permit Number 19714 | 6005847.32276765 | 2105836.20953391 | 37.7625557059029 | -122.42292098007499 | (37.7625557059029, -122.422920980075) | ||
| 79930 | 79930 | 66306 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 311 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29421 | 6000730.96676364 | 2094981.50970271 | 37.7324612706981 | -122.439838262312 | (37.7324612706981, -122.439838262312) | ||
| 80265 | 80265 | 63835 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 480 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24525 | 6007455.04270761 | 2096578.56376841 | 37.737226890345 | -122.41670457837601 | (37.737226890345, -122.416704578376) | ||
| 80272 | 80272 | 67106 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1422 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1992 12:00:00 AM | Permit Number 30521 | 5994302.05947846 | 2105826.4023092 | 37.7618705618217 | -122.46285084168301 | (37.7618705618217, -122.462850841683) | ||
| 80546 | 80546 | 64823 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 324 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25832 | 6002281.26415206 | 2109593.58721525 | 37.7726706787738 | -122.435523472346 | (37.7726706787738, -122.435523472346) | ||
| 81066 | 81066 | 57575 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 30 Beverly St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1994 12:00:00 AM | Permit Number 16442 | 5991446.93129096 | 2089419.02625002 | 37.7166552263353 | -122.471529877911 | (37.7166552263353, -122.471529877911) | ||
| 81174 | 81174 | 37689 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2000 12:00:00 AM | Permit Number 43282 | 6007841.95638313 | 2105703.00432184 | 37.7623023025462 | -122.416012813552 | (37.7623023025462, -122.416012813552) | ||
| 81514 | 81514 | 83403 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 24 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50775 | 6000910.29193694 | 2092966.50207531 | 37.7269387297254 | -122.439073931559 | (37.7269387297254, -122.439073931559) | ||
| 81946 | 81946 | 37921 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1433 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2002 12:00:00 AM | Permit Number 44597 | 6013051.43972244 | 2106572.53658415 | 37.764981363166704 | -122.39805604577299 | (37.7649813631667, -122.398056045773) | ||
| 82007 | 82007 | 45318 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 651 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44155 | 5993484.7456852 | 2090166.18126819 | 37.718824416648005 | -122.464540445707 | (37.718824416648, -122.464540445707) | ||
| 82646 | 82646 | 42355 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 9 | 8x90 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 82659 | 82659 | 68789 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2338 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32726 | 5992037.40889194 | 2099520.42913846 | 37.7444253016329 | -122.470224079807 | (37.7444253016329, -122.470224079807) | ||
| 83499 | 83499 | 48013 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1991 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45735 | 5991253.49588687 | 2101875.72214117 | 37.7508469733877 | -122.47310639275801 | (37.7508469733877, -122.473106392758) | ||
| 83568 | 83568 | 60182 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 64 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1982 12:00:00 AM | Permit Number 19715 | 6005801.28958409 | 2105727.07873438 | 37.7622534608678 | -122.42307243517901 | (37.7622534608678, -122.423072435179) | ||
| 84068 | 84068 | 66397 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 508 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29523 | 6007446.33784222 | 2096483.57459282 | 37.7369655813708 | -122.416727947771 | (37.7369655813708, -122.416727947771) | ||
| 84259 | 84259 | 68648 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1935 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32553 | 5990620.64023794 | 2102219.83857431 | 37.7517551651121 | -122.475319963854 | (37.7517551651121, -122.475319963854) | ||
| 84355 | 84355 | 64836 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 420 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1989 12:00:00 AM | Permit Number 25845 | 6003164.08916748 | 2099517.74214557 | 37.745054922078 | -122.43175015328899 | (37.745054922078, -122.431750153289) | ||
| 84655 | 84655 | 66893 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30211 | 6007590.04442076 | 2097728.05974103 | 37.7403907448612 | -122.41631920740801 | (37.7403907448612, -122.416319207408) | ||
| 85271 | 85271 | 66307 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 312 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29422 | 6000783.041717201 | 2094985.88569991 | 37.732476250278104 | -122.439658540918 | (37.7324762502781, -122.439658540918) | ||
| 85353 | 85353 | 49472 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 3330@ VALENCIA 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/2003 12:00:00 AM | Permit Number 46397 | 6006124.66921915 | 2103195.53921104 | 37.755320686852706 | -122.42177416217899 | (37.7553206868527, -122.421774162179) | ||
| 86037 | 86037 | 66923 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 196 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30244 | 6007541.39171999 | 2097769.00500385 | 37.740500435503 | -122.41649032932399 | (37.740500435503, -122.416490329324) | ||
| 86236 | 86236 | 67173 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 308 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30617 | 6006778.80431339 | 2096277.81486238 | 37.7363630429498 | -122.41902132405599 | (37.7363630429498, -122.419021324056) | ||
| 86361 | 86361 | 64828 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 268 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25837 | 6004831.1974382 | 2099031.73640655 | 37.7438148210139 | -122.42595099579799 | (37.7438148210139, -122.425950995798) | ||
| 86441 | 86441 | 65535 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 3811 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1996 12:00:00 AM | Permit Number 28426 | 6004188.15426377 | 2105377.14964975 | 37.7612014771427 | -122.428626716937 | (37.7612014771427, -122.428626716937) | ||
| 88263 | 88263 | 63989 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 445 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | Permit Number 24735 | 6002297.0656458 | 2100886.57142057 | 37.74876421944229 | -122.434846033464 | (37.7487642194423, -122.434846033464) | ||
| 88765 | 88765 | 42344 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 8 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 89583 | 89583 | 121050 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2650 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006281.0 | 2119745.0 | 37.800770307215295 | -122.42240936075501 | (37.8007703072153, -122.422409360755) | ||||
| 89849 | 89849 | 69042 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1315 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33049 | 5983966.84504954 | 2106204.15933041 | 37.762307073811606 | -122.498623613567 | (37.7623070738116, -122.498623613567) | ||
| 90365 | 90365 | 64877 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2578 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/1989 12:00:00 AM | Permit Number 25899 | 5989272.97531246 | 2097804.00173263 | 37.7395522287807 | -122.479657246034 | (37.7395522287807, -122.479657246034) | ||
| 92076 | 92076 | 30723 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 450 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34623 | 6004402.09076898 | 2109822.75168299 | 37.7734201339954 | -122.428203638325 | (37.7734201339954, -122.428203638325) | ||
| 92578 | 92578 | 56611 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 131 Chaves Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/1992 12:00:00 AM | Permit Number 30977 | 5996730.28293802 | 2098448.69823617 | 37.741752788460296 | -122.453919799435 | (37.7417527884603, -122.453919799435) | ||
| 92636 | 92636 | 68664 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 211 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32571 | 5993343.03467885 | 2114079.66644038 | 37.7844765349697 | -122.46676767712 | (37.7844765349697, -122.46676767712) | ||
| 92827 | 92827 | 68848 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32811 | 5999239.62014085 | 2094052.0632873 | 37.729824224531605 | -122.444927391996 | (37.7298242245316, -122.444927391996) | ||
| 93047 | 93047 | 33939 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 378 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 37898 | 6003089.72357803 | 2091687.1316723998 | 37.72354963405 | -122.431448393386 | (37.72354963405, -122.431448393386) | ||
| 93318 | 93318 | 63838 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 310 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24529 | 6007512.21907746 | 2097215.58579661 | 37.7389792281053 | -122.416552004438 | (37.7389792281053, -122.416552004438) | ||
| 94346 | 94346 | 65256 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1059 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28055 | 6009469.52961682 | 2103013.30669194 | 37.7550083744364 | -122.410193718367 | (37.7550083744364, -122.410193718367) | ||
| 94615 | 94615 | 66308 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 324 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29423 | 6000783.52973512 | 2095017.02999143 | 37.732561793059396 | -122.439659085695 | (37.7325617930594, -122.439659085695) | ||
| 95130 | 95130 | 66660 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1500 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 3x3 | Permit Number 31265 | 6016229.06481316 | 2097072.60827917 | 37.7390730165912 | -122.386402918839 | (37.7390730165912, -122.386402918839) |
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");