Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72893 | 72893 | 45336 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1239 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2001 12:00:00 AM | 8 | Permit Number 44167 | 6013480.5093 | 2106599.06732 | 37.7650780990102 | -122.396573850905 | (37.7650780990102, -122.396573850905) | |
| 73510 | 73510 | 82804 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 46 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/2005 12:00:00 AM | 7 | 6000854.60594 | 2092857.1831900002 | 37.7266353963958 | -122.43925860430001 | (37.7266353963958, -122.4392586043) | ||
| 73562 | 73562 | 193578 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016715.48057 | 2102629.85839 | 37.7543589967884 | -122.385108196298 | (37.7543589967884, -122.385108196298) | ||||
| 74266 | 74266 | 193576 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6016775.537380001 | 2102634.6197099998 | 37.7543753923365 | -122.384900834212 | (37.7543753923365, -122.384900834212) | ||||
| 74717 | 74717 | 34597 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 256 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 12 | Permit Number 38291 | 5999057.300369999 | 2115724.6203 | 37.7893212727094 | -122.447116776012 | (37.7893212727094, -122.447116776012) | |
| 74867 | 74867 | 193580 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6016656.51597 | 2102626.40234 | 37.754346245297704 | -122.385311872064 | (37.7543462452977, -122.385311872064) | ||||
| 75160 | 75160 | 42318 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 301 Edna St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.729107090700396 | -122.44665415584801 | (37.7291070907004, -122.446654155848) | ||
| 75365 | 75365 | 55279 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1227 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1972 12:00:00 AM | 5 | Permit Number 11205 | 5988291.3507 | 2106938.6555 | 37.76457647032 | -122.483720807179 | (37.76457647032, -122.483720807179) | ||
| 75512 | 75512 | 60228 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1419 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1982 12:00:00 AM | 7 | Permit Number 19778 | 5988337.2114 | 2105628.2708 | 37.760981180898796 | -122.48346611801901 | (37.7609811808988, -122.483466118019) | |
| 75916 | 75916 | 34596 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 256 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | Permit Number 38291 | 5999061.1921 | 2115710.40852 | 37.789282473259796 | -122.447102287952 | (37.7892824732598, -122.447102287952) | |
| 76389 | 76389 | 81851 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 234X Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | 6 | 6009256.8715699995 | 2113623.1957099997 | 37.7841287454965 | -122.41167877497699 | (37.7841287454965, -122.411678774977) | ||
| 78345 | 78345 | 41817 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 15 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42203 | 6000006.05115839 | 2112265.23203581 | 37.779876850144504 | -122.443585609483 | (37.7798768501445, -122.443585609483) | ||
| 78372 | 78372 | 38127 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2601 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40291 | 5987686.55551532 | 2107103.11265871 | 37.7649928008384 | -122.485824675941 | (37.7649928008384, -122.485824675941) | ||
| 78392 | 78392 | 41405 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 78450 | 78450 | 40984 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 78585 | 78585 | 41003 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Illinois St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.38723948899599 | (37.7563094360414, -122.387239488996) | |||
| 78655 | 78655 | 41040 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 78737 | 78737 | 31156 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 291 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42627 | 5998170.06868325 | 2093774.97571129 | 37.7290023079752 | -122.448604988547 | (37.7290023079752, -122.448604988547) | ||
| 79451 | 79451 | 41019 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100 Illinois St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | |||
| 80027 | 80027 | 46691 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44820 | 5991711.18613678 | 2105195.27676174 | 37.75998808961071 | -122.47176556697201 | (37.7599880896107, -122.471765566972) | ||
| 80097 | 80097 | 31101 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 25 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34831 | 6000068.0 | 2094066.0 | 37.729909733982296 | -122.442064596859 | (37.7299097339823, -122.442064596859) | ||
| 80286 | 80286 | 42489 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092938.9930099999 | 37.7266456600516 | -122.45224358332099 | (37.7266456600516, -122.452243583321) | ||
| 80811 | 80811 | 35270 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 249 Glenview Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38754 | 5999067.6634639995 | 2100783.79548838 | 37.7482981400857 | -122.446005856491 | (37.7482981400857, -122.446005856491) | ||
| 80834 | 80834 | 41021 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | |||
| 80961 | 80961 | 104879 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381.0 | 37.784945722992504 | -122.488145785283 | (37.7849457229925, -122.488145785283) | |||
| 81323 | 81323 | 96690 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 81817 | 81817 | 42478 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092450.71201 | 37.7253046451535 | -122.4522271205 | (37.7253046451535, -122.4522271205) | ||
| 81821 | 81821 | 46692 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44821 | 5990845.37275011 | 2105216.85962142 | 37.7599972171805 | -122.47476154228501 | (37.7599972171805, -122.474761542285) | ||
| 82117 | 82117 | 41015 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100 Illinois St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | |||
| 82260 | 82260 | 45145 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1794 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | ||
| 82758 | 82758 | 43112 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200 Appleton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.0139999995 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | ||
| 82936 | 82936 | 40999 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Illinois St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.38723948899599 | (37.7563094360414, -122.387239488996) | |||
| 83018 | 83018 | 30859 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1256 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34699 | 5987105.97158028 | 2106720.29614463 | 37.7639078438446 | -122.48780461650401 | (37.7639078438446, -122.487804616504) | |||
| 83061 | 83061 | 41397 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 83262 | 83262 | 96691 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 83351 | 83351 | 33354 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 168 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42328 | 5994249.16422919 | 2093532.93310922 | 37.728112741470106 | -122.462142205261 | (37.7281127414701, -122.462142205261) | ||
| 83475 | 83475 | 40503 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 160 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41573 | 5992838.9416153 | 2093905.66279134 | 37.7290548678482 | -122.467044439005 | (37.7290548678482, -122.467044439005) | ||
| 83595 | 83595 | 41409 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42247 | 6003294.82239032 | 2104743.1831089 | 37.7594101598824 | -122.431671105438 | (37.7594101598824, -122.431671105438) | ||
| 83602 | 83602 | 45147 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1794 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | ||
| 83633 | 83633 | 33254 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2518 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37432 | 5987089.34275763 | 2098119.32468859 | 37.7402909313254 | -122.487230356038 | (37.7402909313254, -122.487230356038) | ||
| 83648 | 83648 | 41016 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100 Illinois St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | |||
| 83904 | 83904 | 34200 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 310 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | Permit Number 38019 | 6004056.26152791 | 2096819.06663407 | 37.737695510104295 | -122.428472860635 | (37.7376955101043, -122.428472860635) | |||
| 84089 | 84089 | 35895 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 225 Industrial St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | ||
| 84323 | 84323 | 52932 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 189 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48918 | 6000194.36437989 | 2092360.19829328 | 37.7252331965683 | -122.441505382551 | (37.7252331965683, -122.441505382551) | ||
| 84412 | 84412 | 37915 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1310 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45463 | 6013387.28238112 | 2106643.29255824 | 37.7651943429343 | -122.396899403082 | (37.7651943429343, -122.396899403082) | ||
| 84576 | 84576 | 35272 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 251 Glenview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38755 | 5999077.63738514 | 2100785.4161936003 | 37.748303159688795 | -122.44597148362 | (37.7483031596888, -122.44597148362) | ||
| 84821 | 84821 | 46840 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 323 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44911 | 6004343.05626617 | 2090535.8229652 | 37.7204593479865 | -122.427033881485 | (37.7204593479865, -122.427033881485) | ||
| 84892 | 84892 | 42485 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44826 | 5997092.52001 | 2092229.35701 | 37.724696732278204 | -122.45221865729799 | (37.7246967322782, -122.452218657298) | ||
| 84925 | 84925 | 50278 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 430 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46981 | 6005373.95050749 | 2095210.43455878 | 37.733353044965796 | -122.423802623394 | (37.7333530449658, -122.423802623394) | ||
| 85210 | 85210 | 31613 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 367 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | Permit Number 35134 | 5987438.17691479 | 2113501.64932662 | 37.782546912742504 | -122.48715372973 | (37.7825469127425, -122.48715372973) | |||
| 85246 | 85246 | 42404 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 162 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42557 | 6000335.92086127 | 2094383.70532934 | 37.7307973438148 | -122.441161150695 | (37.7307973438148, -122.441161150695) | ||
| 85252 | 85252 | 39851 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 85253 | 85253 | 42406 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 500 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42570 | 5998771.97804914 | 2095002.7653645999 | 37.7324079282936 | -122.446612451749 | (37.7324079282936, -122.446612451749) | ||
| 85478 | 85478 | 52487 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 349@ ANDOVER Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 14 | Permit Number 48597 | 6006928.39742445 | 2096056.46353797 | 37.735763683776604 | -122.418488426042 | (37.7357636837766, -122.418488426042) | |
| 86103 | 86103 | 34109 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1398 Plymouth Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 86233 | 86233 | 32501 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 42 Bache St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37006 | 6007173.83127039 | 2095597.26790323 | 37.7345166473806 | -122.417607327621 | (37.7345166473806, -122.417607327621) | ||
| 86693 | 86693 | 42025 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 171 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42348 | 5993627.24240997 | 2093940.95109531 | 37.72919723077929 | -122.464321804087 | (37.7291972307793, -122.464321804087) | ||
| 86742 | 86742 | 42490 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092919.46201 | 37.726592156863205 | -122.452234673085 | (37.7265921568632, -122.452234673085) | ||
| 86871 | 86871 | 39121 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 687x CAPP ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40805 | 6007356.9 | 2103329.2 | 37.755757100206 | -122.417522200164 | (37.755757100206, -122.417522200164) | |||
| 86886 | 86886 | 44390 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 15 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.43616909431101 | (37.7132458927569, -122.436169094311) | ||
| 87330 | 87330 | 42486 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997099.03001 | 2092780.57301 | 37.726210614083705 | -122.45223590817899 | (37.7262106140837, -122.452235908179) | ||
| 87382 | 87382 | 41005 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Illinois St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.38723948899599 | (37.7563094360414, -122.387239488996) | |||
| 87471 | 87471 | 41023 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | |||
| 87552 | 87552 | 50508 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 502 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47143 | 6002555.80481261 | 2090259.94955548 | 37.719600635122795 | -122.43319212748301 | (37.7196006351228, -122.433192127483) | ||
| 87587 | 87587 | 33801 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1411 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/1996 12:00:00 AM | Permit Number 37822 | 5989260.68046067 | 2105731.95209097 | 37.761319566555 | -122.480279867052 | (37.761319566555, -122.480279867052) | |||
| 87774 | 87774 | 40986 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 87778 | 87778 | 42432 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 158 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42580 | 5999029.90712568 | 2093520.1665854 | 37.7283517896397 | -122.44561415687001 | (37.7283517896397, -122.44561415687) | ||
| 88135 | 88135 | 42271 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42510 | 5987162.5410432 | 2105043.61217294 | 37.7593074299184 | -122.487485787682 | (37.7593074299184, -122.487485787682) | ||
| 88323 | 88323 | 39123 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 685 CAPP ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40805 | 6007350.4 | 2103329.1 | 37.755756459886896 | -122.417544672216 | (37.7557564598869, -122.417544672216) | |||
| 88361 | 88361 | 45148 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1794 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | ||
| 88372 | 88372 | 50052 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 695 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46783 | 6002430.83351351 | 2104175.19952785 | 37.7578016026102 | -122.43461858524401 | (37.7578016026102, -122.434618585244) | ||
| 88412 | 88412 | 42325 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 515 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42538 | 5998745.13338347 | 2094431.74877042 | 37.730838517872 | -122.446664189846 | (37.730838517872, -122.446664189846) | ||
| 88433 | 88433 | 45146 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1794 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 44001 | 5997992.79330429 | 2108930.04018436 | 37.7706042491421 | -122.450309844744 | (37.7706042491421, -122.450309844744) | ||
| 88476 | 88476 | 41008 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.38723948899599 | (37.7563094360414, -122.387239488996) | |||
| 88840 | 88840 | 42328 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 640 Edna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42539 | 5998596.9019044 | 2094811.5025333 | 37.7318727635975 | -122.447203968283 | (37.7318727635975, -122.447203968283) | ||
| 88964 | 88964 | 40469 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 251 Harold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41554 | 5996794.30906624 | 2091457.62107189 | 37.722560639803795 | -122.453193843047 | (37.7225606398038, -122.453193843047) | ||
| 89617 | 89617 | 96689 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3132@32nd Ave Clement St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 89731 | 89731 | 40978 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1495 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | |||
| 89775 | 89775 | 40981 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1495 Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | |||
| 90050 | 90050 | 40988 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 90184 | 90184 | 44408 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1201 Naples St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43761 | 6001148.59414975 | 2087417.50046792 | 37.711715976255796 | -122.437852856075 | (37.7117159762558, -122.437852856075) | ||
| 90229 | 90229 | 40983 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | |||
| 90296 | 90296 | 42178 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 540 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42463 | 6010231.08590939 | 2108722.60367253 | 37.770727467539295 | -122.40796262268299 | (37.7707274675393, -122.407962622683) | |||
| 90470 | 90470 | 42480 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092500.6250099998 | 37.7254416323021 | -122.452234471094 | (37.7254416323021, -122.452234471094) | ||
| 90821 | 90821 | 44385 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 185 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.708252829485296 | -122.433679745726 | (37.7082528294853, -122.433679745726) | ||
| 90897 | 90897 | 41408 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 91276 | 91276 | 42420 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 516 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42887 | 5998662.31867711 | 2095004.42234287 | 37.7324062134589 | -122.446991687536 | (37.7324062134589, -122.446991687536) | ||
| 91339 | 91339 | 64659 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 25 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1988 12:00:00 AM | Permit Number 25586 | 6007608.44744383 | 2099294.10346884 | 37.744691787676395 | -122.41636647215599 | (37.7446917876764, -122.416366472156) | |||
| 91647 | 91647 | 41393 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 91969 | 91969 | 33076 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1462 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37334 | 6010606.01223668 | 2119484.72024711 | 37.8002986697641 | -122.40742458550699 | (37.8002986697641, -122.407424585507) | ||
| 92070 | 92070 | 30864 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 265 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34702 | 6003455.83546905 | 2100949.65724805 | 37.7490031605747 | -122.430843516485 | (37.7490031605747, -122.430843516485) | |||
| 92091 | 92091 | 42492 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997101.20001 | 2092826.1460099998 | 37.7263358710664 | -122.45223169353999 | (37.7263358710664, -122.45223169354) | ||
| 92234 | 92234 | 43376 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 433 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43124 | 6001838.70393006 | 2103323.4801791 | 37.755429354087504 | -122.436605448479 | (37.7554293540875, -122.436605448479) | ||
| 92777 | 92777 | 42431 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 158 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42580 | 5999029.90712568 | 2093520.1665854 | 37.7283517896397 | -122.44561415687001 | (37.7283517896397, -122.44561415687) | ||
| 92994 | 92994 | 42314 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 200X STAPLES AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998726.0 | 2093843.0 | 37.7292208591283 | -122.446687991949 | (37.7292208591283, -122.446687991949) | ||
| 93464 | 93464 | 42507 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 134 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42621 | 5999185.65268626 | 2093811.75019854 | 37.7291613007921 | -122.445096693184 | (37.7291613007921, -122.445096693184) | ||
| 93551 | 93551 | 42466 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 124 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47067 | 5998634.60353 | 2093230.01481651 | 37.727532524187495 | -122.446959862935 | (37.7275325241875, -122.446959862935) | ||
| 93654 | 93654 | 40976 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1495 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | Permit Number 41815 | 6016236.41509471 | 2102138.50020991 | 37.7529833183766 | -122.386730679564 | (37.7529833183766, -122.386730679564) | |||
| 93871 | 93871 | 39805 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1920 41st Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 94153 | 94153 | 42451 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 534 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42594 | 5997888.12500218 | 2095286.48921964 | 37.7331364399295 | -122.449688562745 | (37.7331364399295, -122.449688562745) |
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");