Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 626 | 626 | 251342 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 638 | 638 | 251341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 5259 | 5259 | 42922 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 5550 | 5550 | 37365 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 12187 | 12187 | 50191 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46897 | ||||||||
| 13274 | 13274 | 187630 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4255x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2015 05:35:00 PM | 3x3 | 5981269.0 | 2105492.0 | 37.760193098921796 | -122.50790142928699 | (37.7601930989218, -122.507901429287) | ||
| 17069 | 17069 | 232077 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6006071.88671 | 2096082.4988799999 | 37.7357869155289 | -122.42145157094299 | (37.7357869155289, -122.421451570943) | ||||
| 17982 | 17982 | 40992 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500288997 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | ||
| 19134 | 19134 | 42608 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | ||
| 19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | 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) | ||
| 19682 | 19682 | 46465 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | |||
| 30527 | 30527 | 33381 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.871562201 | 2093773.0831922002 | 37.72867362771839 | -122.46806524141199 | (37.7286736277184, -122.468065241412) | |||
| 30543 | 30543 | 104420 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.776744114760106 | -122.504756894571 | (37.7767441147601, -122.504756894571) | ||||
| 37390 | 37390 | 39700 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.45665278849701 | (37.7319575477065, -122.456652788497) | ||
| 37404 | 37404 | 40499 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 44 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.731292009719894 | -122.466191234844 | (37.7312920097199, -122.466191234844) | ||
| 38344 | 38344 | 33199 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | ||
| 42982 | 42982 | 39843 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3151 Ortega St | 16 | 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) | ||
| 50170 | 50170 | 42509 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42623 | 5999007.81241244 | 2093762.41150779 | 37.7290156761066 | -122.44570795274099 | (37.7290156761066, -122.445707952741) | ||
| 50499 | 50499 | 39699 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 360 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.45665278849701 | (37.7319575477065, -122.456652788497) | ||
| 53786 | 53786 | 33351 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 156 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42327 | 5994316.91365045 | 2093552.57844974 | 37.7281705833725 | -122.461909418866 | (37.7281705833725, -122.461909418866) | ||
| 60912 | 60912 | 42493 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.9530099998 | 37.726434250767205 | -122.45223052530301 | (37.7264342507672, -122.452230525303) | ||
| 62498 | 62498 | 44721 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1996 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2001 12:00:00 AM | Permit Number 43840 | 5989758.20628326 | 2101785.10530384 | 37.7505114749608 | -122.47827055966499 | (37.7505114749608, -122.478270559665) | |||
| 64067 | 64067 | 37478 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1375 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767462 | 5991110.32977564 | 2106057.84846708 | 37.76232169867271 | -122.473906549358 | (37.7623216986727, -122.473906549358) | |
| 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) | ||
| 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) | ||
| 78388 | 78388 | 93529 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 325 China Basin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | ||
| 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) | |||
| 78628 | 78628 | 100048 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1445 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2012 12:00:00 AM | 3x3 | Permit Number 769137 | 5991161.0 | 2110614.0 | 37.7748345969519 | -122.47406374416 | (37.7748345969519, -122.47406374416) | ||
| 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) | |||
| 79937 | 79937 | 43271 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 449 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50498 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 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) | ||
| 80551 | 80551 | 93524 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 325 China Basin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | ||
| 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) | ||
| 81915 | 81915 | 95664 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 298 Cambridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767424 | 6006728.0 | 2093095.0 | 37.7276208697995 | -122.41897129934999 | (37.7276208697995, -122.41897129935) | |
| 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) | ||
| 82398 | 82398 | 30467 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 485 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1956 12:00:00 AM | 3x3 | Permit Number 115 | 6010634.96465666 | 2119592.97998716 | 37.800597544946704 | -122.407332034382 | (37.8005975449467, -122.407332034382) | ||
| 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) | ||
| 83598 | 83598 | 88611 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 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) | |||
| 84071 | 84071 | 114286 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1801X 16TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x4 | 5991146.0 | 2103109.0 | 37.7542270070727 | -122.473568070103 | (37.7542270070727, -122.473568070103) | ||||
| 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) | ||
| 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) | ||
| 86360 | 86360 | 36928 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 901 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51504 | 6000612.32634681 | 2101962.60570598 | 37.751622953989205 | -122.440749012812 | (37.7516229539892, -122.440749012812) | ||
| 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) | |||
| 88686 | 88686 | 113666 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1435 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013045.0 | 2106578.0 | 37.7649960058226 | -122.39807870262501 | (37.7649960058226, -122.398078702625) | ||||
| 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) |
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");