trees
1,746 rows where qSpecies_id = 10 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
341 | 232113 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1991 12:00:00 AM | 24 | 4x4 | Permit Number 29534 | 6008027.37409 | 2096368.31937 | 37.7366817787289 | -122.414710885994 | (37.7366817787289, -122.414710885994) | 2 | 7 | 7 | 28859 | 2 | |
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 | ||
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 | ||
3589 | 254266 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
3994 | 256688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1477 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782620 | |||||||||||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||||||||||||||
13173 | 25969 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2121 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012170.05975 | 2097512.80398 | 37.7400561799102 | -122.400468107084 | (37.7400561799102, -122.400468107084) | 10 | 3 | 8 | 58 | 1 | ||
13681 | 27548 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1301X Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 8 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | |||||||||||||
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 | |||||||||||||
15471 | 27568 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
16089 | 35760 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1312 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 11 | 3x3 | Permit Number 39024 | 6007125.06235959 | 2107895.69286433 | 37.7682825792913 | -122.418647786971 | (37.7682825792913, -122.418647786971) | 8 | 4 | 7 | 28853 | 19 | |
16307 | 254265 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
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 | |||
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 | |||
23091 | 27563 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
23974 | 25963 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2165X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012113.82333 | 2097630.4428 | 37.7403760548667 | -122.400670812787 | (37.7403760548667, -122.400670812787) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
24894 | 13115 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1626 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 60 | 3x3 | 6004582.24244 | 2119837.84859 | 37.8009292710883 | -122.428294391798 | (37.8009292710883, -122.428294391798) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
25486 | 24126 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 140X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1997 12:00:00 AM | 9 | 3X3 | 6016343.6401634 | 2095980.6654178 | 37.7360811036021 | -122.385930671948 | (37.7360811036021, -122.385930671948) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
27013 | 10861 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X HUDSON AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
27916 | 1947 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 12 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1995 12:00:00 AM | 6 | 3X4 | 6017600.7966789 | 2095158.5318762 | 37.7338931798791 | -122.381526972425 | (37.7338931798791, -122.381526972425) | 10 | 3 | 8 | 58 | 1 | ||
28008 | 37382 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 755 Morse St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) | 9 | 7 | 6 | 28861 | 5 |
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 | |||
30987 | 37490 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1645 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 6 | 3x3 | Permit Number 44817 | 5990669.89320033 | 2106519.30844016 | 37.7635632233668 | -122.475463533504 | (37.7635632233668, -122.475463533504) | 1 | 8 | 3 | 56 | 12 |
31099 | 27559 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
32103 | 27561 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
32813 | 27552 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 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 | ||||
34630 | 15773 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 4787 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1995 12:00:00 AM | 6 | 3X3 | 6001512.82985 | 2091082.39205 | 37.7217996565285 | -122.436856153691 | (37.7217996565285, -122.436856153691) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
34824 | 25925 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1900 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1997 12:00:00 AM | 12 | 3x3 | 6013379.37918 | 2096773.80644 | 37.7380944133833 | -122.396234966455 | (37.7380944133833, -122.396234966455) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
36244 | 35759 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1312 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 11 | 3x3 | Permit Number 39024 | 6007125.06235959 | 2107895.69286433 | 37.7682825792913 | -122.418647786971 | (37.7682825792913, -122.418647786971) | 8 | 4 | 7 | 28853 | 19 | |
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 | ||
40965 | 35762 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1312 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 11 | 3x3 | Permit Number 39024 | 6007125.06235959 | 2107895.69286433 | 37.7682825792913 | -122.418647786971 | (37.7682825792913, -122.418647786971) | 8 | 4 | 7 | 28853 | 19 | |
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 | |||
42161 | 10857 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 |
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) );