trees
1,746 rows where qSpecies_id = 10 sorted by DBH
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 264965 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 951 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994993 | 2090257 | 37.7191606150529 | -122.45933361899 | (37.7191606150529, -122.45933361899) | 9 | 8 | 6 | 28861 | 24 | ||||
997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
1214 | 44389 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
1539 | 39700 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
1711 | 261518 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 515 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | Width 3ft | 5982833.25943 | 2112233.81526 | 37.7787962221578 | -122.50299059962 | (37.7787962221578, -122.50299059962) | 11 | 6 | 2 | 55 | 26 | |||
1981 | 40499 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 44 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1999 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.7312920097199 | -122.466191234844 | (37.7312920097199, -122.466191234844) | 9 | 8 | 4 | 59 | 40 | ||
2441 | 37478 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1375 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767462 | 5991110.32977564 | 2106057.84846708 | 37.7623216986727 | -122.473906549358 | (37.7623216986727, -122.473906549358) | 1 | 8 | 11 | 56 | 12 | |
3228 | 41394 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
3316 | 40992 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | ||
4677 | 104420 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 622 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770538 | 5982306.9 | 2111497.7 | 37.7767441147601 | -122.504756894571 | (37.7767441147601, -122.504756894571) | 11 | 6 | 2 | 55 | 26 | ||||
4973 | 33381 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.8715622 | 2093773.0831922 | 37.7286736277184 | -122.468065241412 | (37.7286736277184, -122.468065241412) | 9 | 8 | 4 | 59 | 40 | |||
5794 | 255199 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
5942 | 37366 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 125 Street | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39871 | |||||||||||||
6143 | 41891 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 401 Duboce Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42259 | 6004099.97108515 | 2108358.83625404 | 37.7693834800973 | -122.429144312501 | (37.7693834800973, -122.429144312501) | 7 | 9 | 5 | 28862 | 3 | |||
6537 | 261310 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1751 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987774 | 2103374 | 37.7547587692818 | -122.485248582837 | (37.7547587692818, -122.485248582837) | 1 | 8 | 3 | 56 | 35 | ||||
6785 | 255190 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
7061 | 259664 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1850 36th Ave | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5985092 | 2102600 | 37.7524769742467 | -122.494466484126 | (37.7524769742467, -122.494466484126) | 1 | 8 | 3 | 56 | 35 | ||||
7159 | 33199 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | 1 | 5 | 4 | 59 | 40 | ||
7831 | 43263 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
8203 | 33351 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 156 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42327 | 5994316.91365045 | 2093552.57844974 | 37.7281705833725 | -122.461909418866 | (37.7281705833725, -122.461909418866) | 9 | 8 | 4 | 59 | 40 | ||
9576 | 258366 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008411.83681 | 2093627.45022 | 37.7291775379757 | -122.413187871426 | (37.7291775379757, -122.413187871426) | 9 | 3 | 7 | 309 | 28 | ||||
9925 | 255197 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
9960 | 39843 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
10071 | 255198 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10131 | 255195 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10267 | 255196 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10606 | 46465 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |||
11421 | 255616 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 334 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006694 | 2104159 | 37.7579982171346 | -122.419873605129 | (37.7579982171346, -122.419873605129) | 2 | 4 | 7 | 28859 | 19 | ||||
12325 | 42608 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | 13 | 9 | 1 | 57 | 17 | ||
12500 | 255191 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12563 | 46339 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3724 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50545 | 6005683.95677825 | 2100834.56351367 | 37.7488131299105 | -122.423130469903 | (37.7488131299105, -122.423130469903) | 2 | 4 | 5 | 28859 | 19 | ||
12912 | 50271 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 46 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46975 | 6003961.77190842 | 2095882.86717576 | 37.7351195713487 | -122.428732836762 | (37.7351195713487, -122.428732836762) | 2 | 7 | 5 | 28861 | 7 | ||
13092 | 261764 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 130 Bartlett St | 2 | Front Yard : Cutout | Tree | Private 2 | 4x4 | 6006663 | 2102839 | 37.7543720553146 | -122.419887150249 | (37.7543720553146, -122.419887150249) | 2 | 4 | 7 | 28859 | 19 | ||||
13119 | 42922 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42829 | ||||||||||||||
13695 | 39699 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
13719 | 264662 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1070 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014517.40872 | 2089968.05117 | 37.7194704392608 | -122.391824453064 | (37.7194704392608, -122.391824453064) | 10 | 3 | 8 | 58 | 1 | |||
13782 | 50191 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46897 | |||||||||||||
14095 | 262078 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1201 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001148 | 2087377 | 37.7116047371551 | -122.437852010648 | (37.7116047371551, -122.437852010648) | 9 | 7 | 6 | 28861 | 5 | ||||
14989 | 37365 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 125 Street | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39871 | |||||||||||||
15406 | 255194 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16501 | 255192 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16807 | 255193 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
17329 | 42509 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42623 | 5999007.81241244 | 2093762.41150779 | 37.7290156761066 | -122.445707952741 | (37.7290156761066, -122.445707952741) | 9 | 7 | 4 | 28861 | 40 | ||
18335 | 44721 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1996 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2001 12:00:00 AM | Permit Number 43840 | 5989758.20628326 | 2101785.10530384 | 37.7505114749608 | -122.478270559665 | (37.7505114749608, -122.478270559665) | 1 | 8 | 3 | 29491 | 35 | |||
19473 | 261023 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 631 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5985931 | 2111585 | 37.7771963436428 | -122.492226661995 | (37.7771963436428, -122.492226661995) | 11 | 6 | 2 | 55 | 26 | |||
19648 | 114286 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1801X 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 5991146 | 2103109 | 37.7542270070727 | -122.473568070103 | (37.7542270070727, -122.473568070103) | 1 | 8 | 4 | 56 | 12 | ||||
19965 | 42912 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2624 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42823 | 6010365.23344045 | 2103432.32493154 | 37.756209071018 | -122.40712563844 | (37.756209071018, -122.40712563844) | 10 | 4 | 7 | 28859 | 19 | ||
20237 | 42318 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 301 Edna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.7291070907004 | -122.446654155848 | (37.7291070907004, -122.446654155848) | 9 | 7 | 4 | 28861 | 40 | ||
20247 | 41013 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
21519 | 43264 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
21618 | 47992 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2566 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2002 12:00:00 AM | Permit Number 45724 | 5991766.18886857 | 2097968.53532051 | 37.7401485137394 | -122.471048858974 | (37.7401485137394, -122.471048858974) | 1 | 8 | 4 | 59 | 40 | |||
21738 | 33348 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 120 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37485 | 5994502.21171905 | 2093669.50135187 | 37.7285022911433 | -122.461277313418 | (37.7285022911433, -122.461277313418) | 9 | 8 | 4 | 59 | 40 | ||
22220 | 40990 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
22265 | 34205 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 615 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767518 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |
22298 | 39806 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
22461 | 41041 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.7402144368946 | -122.376937636731 | (37.7402144368946, -122.376937636731) | 10 | 3 | 8 | 58 | 1 | |||
22880 | 40985 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | |||
24101 | 35896 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 225 Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | 10 | 3 | 8 | 58 | 1 | ||
24471 | 88613 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 10 Kirkham St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | 15 | 5 | 11 | 56 | 12 | ||
24550 | 43121 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 300 Elsie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2000 12:00:00 AM | Permit Number 42941 | 6006621.15716652 | 2097502.62281264 | 37.7397172147751 | -122.419653252856 | (37.7397172147751, -122.419653252856) | 2 | 7 | 7 | 28859 | 2 | ||
24917 | 33417 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 80 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37527 | 5993258.22068719 | 2093571.67048868 | 37.7281619993725 | -122.465570716095 | (37.7281619993725, -122.465570716095) | 9 | 8 | 4 | 59 | 40 | ||
26385 | 31584 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1894 24th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35120 | 5988803.26989649 | 2102446.27193627 | 37.7522713821241 | -122.481621183041 | (37.7522713821241, -122.481621183041) | 1 | 8 | 3 | 56 | 35 | ||
27275 | 43268 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
28913 | 42414 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 462 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42565 | 5998357.60439451 | 2094413.03350519 | 37.7307649857681 | -122.448002587308 | (37.7307649857681, -122.448002587308) | 9 | 7 | 4 | 59 | 40 | ||
29091 | 41414 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1101 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | Permit Number 42026 | 6008853.95008654 | 2117958.40883134 | 37.7960095757906 | -122.413379432482 | (37.7960095757906, -122.413379432482) | 5 | 1 | 10 | 308 | 21 | |||
29850 | 43267 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
30669 | 40998 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1200 Illinois St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41817 | 6016113.76612701 | 2103352.32554079 | 37.7563094360414 | -122.387239488996 | (37.7563094360414, -122.387239488996) | 10 | 3 | 8 | 28856 | 29 | |||
30783 | 42001 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 130 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42336 | 5993772.38783122 | 2093685.79470402 | 37.7285049990899 | -122.463801515353 | (37.7285049990899, -122.463801515353) | 9 | 8 | 4 | 59 | 40 | |||
31648 | 39798 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
32010 | 41022 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
32971 | 38878 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 64 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40701 | 5995526.21364859 | 2115603.12418033 | 37.788785293559 | -122.459325039477 | (37.788785293559, -122.459325039477) | 11 | 6 | 1 | 54 | 31 | ||
33183 | 39330 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 0 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.384018475054 | (37.7603812969624, -122.384018475054) | 10 | 3 | 8 | 310 | 29 | |||
33244 | 30872 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 587 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34706 | 5996404.87834636 | 2095840.32607721 | 37.7345721715471 | -122.45485651644 | (37.7345721715471, -122.45485651644) | 9 | 7 | 4 | 59 | 40 | |||
33523 | 35770 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3678 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39029 | 6005058.98569186 | 2105477.55224933 | 37.7615264037651 | -122.425622026069 | (37.7615264037651, -122.425622026069) | 8 | 4 | 5 | 28859 | 19 | ||
33637 | 42425 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 571 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42576 | 5998313.53523714 | 2094957.68654916 | 37.7322579549975 | -122.448194144251 | (37.7322579549975, -122.448194144251) | 9 | 7 | 4 | 59 | 40 | ||
33785 | 42488 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997100.11501 | 2092805.52901 | 37.7262791995089 | -122.452233957334 | (37.7262791995089, -122.452233957334) | 9 | 7 | 4 | 28861 | 40 | ||
34385 | 93523 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 325 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||||
34777 | 35217 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2349 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40230 | 5992298.50027325 | 2099442.57015301 | 37.7442266120309 | -122.469315621961 | (37.7442266120309, -122.469315621961) | 1 | 8 | 4 | 29491 | 40 | ||
35404 | 38127 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2601 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40291 | 5987686.55551532 | 2107103.11265871 | 37.7649928008384 | -122.485824675941 | (37.7649928008384, -122.485824675941) | 1 | 8 | 3 | 56 | 35 | ||
35951 | 39709 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 777 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41094 | 5996960.75086515 | 2094978.12726071 | 37.7322366517745 | -122.452872476937 | (37.7322366517745, -122.452872476937) | 9 | 7 | 4 | 59 | 40 | ||
37238 | 39807 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
37242 | 39591 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | Permit Number 41001 | 6012325.10844747 | 2103966.01708403 | 37.7577839574034 | -122.400385164113 | (37.7577839574034, -122.400385164113) | 10 | 3 | 8 | 28856 | 29 | |||
38869 | 41019 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
40102 | 30859 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1256 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34699 | 5987105.97158028 | 2106720.29614463 | 37.7639078438446 | -122.487804616504 | (37.7639078438446, -122.487804616504) | 1 | 8 | 3 | 56 | 35 | |||
40184 | 52932 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 189 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48918 | 6000194.36437989 | 2092360.19829328 | 37.7252331965683 | -122.441505382551 | (37.7252331965683, -122.441505382551) | 9 | 7 | 6 | 28861 | 25 | ||
41220 | 33354 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 168 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42328 | 5994249.16422919 | 2093532.93310922 | 37.7281127414701 | -122.462142205261 | (37.7281127414701, -122.462142205261) | 9 | 8 | 4 | 59 | 40 | ||
41467 | 34200 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 310 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38019 | 6004056.26152791 | 2096819.06663407 | 37.7376955101043 | -122.428472860635 | (37.7376955101043, -122.428472860635) | 2 | 7 | 5 | 63 | 7 | |||
41616 | 35270 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 249 Glenview Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38754 | 5999067.663464 | 2100783.79548838 | 37.7482981400857 | -122.446005856491 | (37.7482981400857, -122.446005856491) | 2 | 5 | 5 | 63 | 38 | ||
41643 | 31101 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 25 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34831 | 6000068 | 2094066 | 37.7299097339823 | -122.442064596859 | (37.7299097339823, -122.442064596859) | 9 | 7 | 4 | 63 | 40 | ||
41998 | 41016 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
42340 | 93524 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 325 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
42704 | 41817 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42203 | 6000006.05115839 | 2112265.23203581 | 37.7798768501445 | -122.443585609483 | (37.7798768501445, -122.443585609483) | 15 | 5 | 1 | 29490 | 16 | ||
43040 | 41409 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42247 | 6003294.82239032 | 2104743.1831089 | 37.7594101598824 | -122.431671105438 | (37.7594101598824, -122.431671105438) | 2 | 4 | 5 | 28862 | 3 | ||
43487 | 100048 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1445 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2012 12:00:00 AM | 3x3 | Permit Number 769137 | 5991161 | 2110614 | 37.7748345969519 | -122.47406374416 | (37.7748345969519, -122.47406374416) | 11 | 6 | 2 | 54 | 26 | ||
43556 | 115180 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2019 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775162 | 5981635.3 | 2101323.4 | 37.7487688795742 | -122.506325467188 | (37.7487688795742, -122.506325467188) | 1 | 8 | 3 | 29491 | 35 | |||
43696 | 43112 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 200 Appleton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 | ||
44393 | 42485 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44826 | 5997092.52001 | 2092229.35701 | 37.7246967322782 | -122.452218657298 | (37.7246967322782, -122.452218657298) | 9 | 7 | 4 | 28861 | 40 | ||
44717 | 41015 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
44757 | 41021 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/1999 12:00:00 AM | Permit Number 41818 | 6016079.81700682 | 2103953.33797233 | 37.757957808739 | -122.387398822745 | (37.757957808739, -122.387398822745) | 10 | 3 | 8 | 28856 | 29 | |||
44975 | 30467 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 485 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1956 12:00:00 AM | 3x3 | Permit Number 115 | 6010634.96465666 | 2119592.97998716 | 37.8005975449467 | -122.407332034382 | (37.8005975449467, -122.407332034382) | 3 | 1 | 10 | 308 | 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );