trees
725 rows where qCaretaker_id = 6 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
125354 | 253413 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 2433 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 3x3 | 5989193.66308 | 2098780.80152 | 37.7422296590049 | -122.480002935505 | (37.7422296590049, -122.480002935505) | 1 | 8 | 3 | 29491 | 35 | |||
103125 | 115402 | Permitted Site 7 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.422461340443 | (37.7357803359495, -122.422461340443) | 2 | 7 | 7 | 28859 | 2 | ||
165984 | 108830 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Port 6 | FUF | 3x3 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | ||||
60693 | 254809 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 571 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/29/2018 12:00:00 AM | 3 | Permit Number 781555 | 5985946.54219 | 2112020.89571 | 37.778394097385 | -122.492205001438 | (37.778394097385, -122.492205001438) | 11 | 6 | 2 | 55 | 26 | |||
129891 | 106680 | Permitted Site 7 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) | 13 | 6 | 1 | 29490 | 27 |
144881 | 106120 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 6x9 | 5992954.7 | 2110649.6 | 37.7750360842588 | -122.467861605393 | (37.7750360842588, -122.467861605393) | 11 | 6 | 2 | 54 | 11 | |||
3206 | 83039 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6018611.72965 | 2097767.00037 | 37.7411112833697 | -122.378212851336 | (37.7411112833697, -122.378212851336) | 10 | 3 | 8 | 58 | 1 | ||||
6877 | 3643 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 79 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017487.6627 | 2098619.8542 | 37.7433910314633 | -122.382158823763 | (37.7433910314633, -122.382158823763) | 10 | 3 | 8 | 58 | 1 | |||
7035 | 3622 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017832.21147 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | 10 | 3 | 8 | 58 | 1 | |||
7185 | 3603 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 39 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018171.24251 | 2098094.76588 | 37.7419869748341 | -122.379758679838 | (37.7419869748341, -122.379758679838) | 10 | 3 | 8 | 58 | 1 | |||
8437 | 83050 | DPW Maintained 1 | Rhamnus californica :: Coffeeberry Tree 320 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | 10 | 3 | 8 | 58 | 1 | ||||
9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
10036 | 83037 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 5 | 6018575.81097 | 2097793.86484 | 37.7411830681528 | -122.378338911137 | (37.7411830681528, -122.378338911137) | 10 | 3 | 8 | 58 | 1 | ||||
10393 | 3666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.7441802162386 | -122.383400533034 | (37.7441802162386, -122.383400533034) | 10 | 3 | 8 | 58 | 1 | ||
10719 | 3608 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 44 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018087.01832 | 2098157.15518 | 37.7421536371939 | -122.380054237523 | (37.7421536371939, -122.380054237523) | 10 | 3 | 8 | 58 | 1 | ||
10762 | 3628 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.381304710649 | (37.7428615520079, -122.381304710649) | 10 | 3 | 8 | 58 | 1 | |||
11075 | 3596 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 32 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:07:00 PM | 3 | 3X3 | 6018288.66955 | 2098007.43076 | 37.7417536466133 | -122.379346585295 | (37.7417536466133, -122.379346585295) | 10 | 3 | 8 | 58 | 1 | ||
11481 | 3673 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.62034 | 37.7444159222737 | -122.383819238476 | (37.7444159222737, -122.383819238476) | 10 | 3 | 8 | 58 | 1 | ||
12701 | 3581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
13263 | 27467 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016160.2227 | 2100486.94206 | 37.7484442654916 | -122.386878998841 | (37.7484442654916, -122.386878998841) | 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 | ||
14274 | 3580 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
15140 | 83033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
17391 | 3602 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.44706 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | 10 | 3 | 8 | 58 | 1 | ||
18663 | 83040 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.377888212277 | (37.740925933998, -122.377888212277) | 10 | 3 | 8 | 58 | 1 | ||||
18840 | 83046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.377512501614 | (37.740707968002, -122.377512501614) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
26841 | 3665 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 101 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017153.34624 | 2098900.71457 | 37.7441437469313 | -122.383334362693 | (37.7441437469313, -122.383334362693) | 10 | 3 | 8 | 58 | 1 | |||
26941 | 3606 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 42 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018122.20462 | 2098131.02661 | 37.7420838344896 | -122.379930757907 | (37.7420838344896, -122.379930757907) | 10 | 3 | 8 | 58 | 1 | |||
28445 | 3667 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.7442173915214 | -122.383463247242 | (37.7442173915214, -122.383463247242) | 10 | 3 | 8 | 58 | 1 | ||
30084 | 3591 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 27 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018372.01456 | 2097944.0595 | 37.7415842377244 | -122.379054002545 | (37.7415842377244, -122.379054002545) | 10 | 3 | 8 | 58 | 1 | ||
30169 | 27537 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016137.08872 | 2102884.43561 | 37.7550260005701 | -122.387126196736 | (37.7550260005701, -122.387126196736) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
31430 | 3675 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 111 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016978.81066 | 2099030.12804 | 37.7444894427423 | -122.383946883753 | (37.7444894427423, -122.383946883753) | 10 | 3 | 8 | 58 | 1 | ||
31657 | 3663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 99 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/12/1990 12:00:00 AM | 3 | 3X3 | 6017184.0839 | 2098879.25737 | 37.744086528482 | -122.383226584333 | (37.744086528482, -122.383226584333) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
33186 | 3613 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.7423214758653 | -122.380345828295 | (37.7423214758653, -122.380345828295) | 10 | 3 | 8 | 58 | 1 | |||
33759 | 83042 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:54:00 PM | 3 | 6018742.83505 | 2097668.8048 | 37.740848882771 | -122.37775271773 | (37.740848882771, -122.37775271773) | 10 | 3 | 8 | 58 | 1 | |||
33883 | 3629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017712.66324 | 2098437.04484 | 37.7429014981049 | -122.381368111942 | (37.7429014981049, -122.381368111942) | 10 | 3 | 8 | 58 | 1 | |||
34219 | 3678 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 114 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016900.55326 | 2099090.71493 | 37.7446514753884 | -122.384221703094 | (37.7446514753884, -122.384221703094) | 10 | 3 | 8 | 58 | 1 | |||
35108 | 3688 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 2 | Median : Cutout | Tree | Port 6 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35545 | 3632 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017663.5913 | 2098472.76802 | 37.7429968775117 | -122.381540274588 | (37.7429968775117, -122.381540274588) | 10 | 3 | 8 | 58 | 1 | |||
35554 | 3584 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/11/1998 12:00:00 AM | 3 | 3X3 | 6018506.82441 | 2097843.80813 | 37.7413163998229 | -122.378580911506 | (37.7413163998229, -122.378580911506) | 10 | 3 | 8 | 58 | 1 | ||
35762 | 3690 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 4 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
38829 | 22089 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6016009.5802 | 2099538.74144 | 37.7458323609698 | -122.387333787882 | (37.7458323609698, -122.387333787882) | 10 | 3 | 8 | 58 | 1 | |||
39148 | 4016 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 700X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/27/2000 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.382788188693 | (37.7506230149756, -122.382788188693) | 10 | 3 | 8 | 58 | 1 | ||
40398 | 3671 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 107 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017047.36981 | 2098978.83891 | 37.7443524031345 | -122.38370624765 | (37.7443524031345, -122.38370624765) | 10 | 3 | 8 | 58 | 1 | |||
41101 | 27541 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1390 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 6 | 3X3 | 6016157.095863 | 2102619.361637 | 37.7542992711205 | -122.387038518734 | (37.7542992711205, -122.387038518734) | 10 | 3 | 8 | 28856 | 29 | ||
41537 | 3684 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 120 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016817.82171 | 2099151.76391 | 37.7448145287778 | -122.384512026728 | (37.7448145287778, -122.384512026728) | 10 | 3 | 8 | 58 | 1 | |||
42308 | 3639 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180002 | -122.381933568796 | (37.743238180002, -122.381933568796) | 10 | 3 | 8 | 58 | 1 | ||
42378 | 27556 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 7 | 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 | ||
44203 | 3575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
44228 | 3670 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 106 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017067.53558 | 2098965.30929 | 37.7443163682077 | -122.383635576218 | (37.7443163682077, -122.383635576218) | 10 | 3 | 8 | 58 | 1 | |||
45116 | 83043 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:49:00 PM | 3 | 6018760.27201 | 2097656.07243 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | 10 | 3 | 8 | 58 | 1 | |||
46225 | 3611 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.29611 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | 10 | 3 | 8 | 58 | 1 | ||
46442 | 3681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.95731 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | 10 | 3 | 8 | 58 | 1 | ||
46985 | 83041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.7408907812923 | -122.377824564564 | (37.7408907812923, -122.377824564564) | 10 | 3 | 8 | 58 | 1 | |||
47677 | 27571 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
47874 | 3638 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | 10 | 3 | 8 | 58 | 1 | |||
49190 | 3634 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 70 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017632.60306 | 2098495.95511 | 37.7430588336066 | -122.381649036799 | (37.7430588336066, -122.381649036799) | 10 | 3 | 8 | 58 | 1 | |||
49765 | 3653 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 89 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017331.73303 | 2098760.60047 | 37.7437688789233 | -122.382707786159 | (37.7437688789233, -122.382707786159) | 10 | 3 | 8 | 58 | 1 | |||
50873 | 3679 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 115 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6016884.1224 | 2099103.28613 | 37.7446850848489 | -122.384279393677 | (37.7446850848489, -122.384279393677) | 10 | 3 | 8 | 58 | 1 | |||
50885 | 4017 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 700X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.382788188693 | (37.7506230149756, -122.382788188693) | 10 | 3 | 8 | 58 | 1 | ||
51450 | 22094 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016017.00918 | 2099367.08567 | 37.7453614410817 | -122.38729612742 | (37.7453614410817, -122.38729612742) | 10 | 3 | 8 | 58 | 1 | |||
53181 | 27578 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 29 | 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 | ||
54162 | 3576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
55257 | 27468 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3255 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016160.2227 | 2100486.94206 | 37.7484442654916 | -122.386878998841 | (37.7484442654916, -122.386878998841) | 10 | 3 | 8 | 58 | 1 | ||
55609 | 3587 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.39842 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) | 10 | 3 | 8 | 58 | 1 | ||
57168 | 27558 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
58070 | 3633 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 69 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017649.0599 | 2098484.04513 | 37.7430270398604 | -122.381591304811 | (37.7430270398604, -122.381591304811) | 10 | 3 | 8 | 58 | 1 | |||
61310 | 27570 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
61953 | 22093 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3400X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016015.95987 | 2099423.81611 | 37.745517153054 | -122.387303712363 | (37.745517153054, -122.387303712363) | 10 | 3 | 8 | 58 | 1 | |||
62490 | 22091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6016010.69646 | 2099489.56952 | 37.7456974068511 | -122.387326498503 | (37.7456974068511, -122.387326498503) | 10 | 3 | 8 | 58 | 1 | ||
62632 | 3577 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
64821 | 27539 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 6 | 3X3 | 6016127.14698 | 2102787.87807 | 37.7547603233662 | -122.38715384385 | (37.7547603233662, -122.38715384385) | 10 | 3 | 8 | 28856 | 29 | ||
66260 | 3682 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
67169 | 3600 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 36 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:14:00 PM | 3 | 3X3 | 6018222.96713 | 2098056.59418 | 37.7418850159701 | -122.379577179554 | (37.7418850159701, -122.379577179554) | 10 | 3 | 8 | 58 | 1 | ||
67468 | 22078 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015962.98615 | 2100528.59711 | 37.7485477189018 | -122.387563950724 | (37.7485477189018, -122.387563950724) | 10 | 3 | 8 | 58 | 1 | ||
70222 | 3618 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | 10 | 3 | 8 | 58 | 1 | |||
71826 | 27553 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
74679 | 3651 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 87 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6017363.38197 | 2098733.24342 | 37.7436955104472 | -122.382596447366 | (37.7436955104472, -122.382596447366) | 10 | 3 | 8 | 58 | 1 | ||
76120 | 3625 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 61 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017781.37492 | 2098384.59743 | 37.7427612812112 | -122.38112687781 | (37.7427612812112, -122.38112687781) | 10 | 3 | 8 | 58 | 1 | |||
76384 | 3647 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.382378924746 | (37.7435463281955, -122.382378924746) | 10 | 3 | 8 | 58 | 1 | ||
79530 | 3657 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 93 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017283.49959 | 2098800.90892 | 37.7438768929081 | -122.382877372202 | (37.7438768929081, -122.382877372202) | 10 | 3 | 8 | 58 | 1 | |||
80049 | 3674 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 110 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:22:00 AM | 3 | 3X3 | 6016998.30504 | 2099015.89853 | 37.7444514490906 | -122.383878484902 | (37.7444514490906, -122.383878484902) | 10 | 3 | 8 | 58 | 1 | ||
81580 | 3644 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 80 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:15:00 AM | 3 | 3X3 | 6017471.84094 | 2098633.68097 | 37.7434281231236 | -122.382214493629 | (37.7434281231236, -122.382214493629) | 10 | 3 | 8 | 58 | 1 | ||
81887 | 3680 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 116 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016866.69606 | 2099115.15257 | 37.7447167041098 | -122.384340477447 | (37.7447167041098, -122.384340477447) | 10 | 3 | 8 | 58 | 1 | |||
82496 | 27535 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.14698 | 2102787.87807 | 37.7547603233662 | -122.38715384385 | (37.7547603233662, -122.38715384385) | 10 | 3 | 8 | 28856 | 29 | ||
82800 | 3599 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 35 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:11:00 PM | 3 | 3X3 | 6018236.38581 | 2098046.32756 | 37.7418575659771 | -122.379530068578 | (37.7418575659771, -122.379530068578) | 10 | 3 | 8 | 58 | 1 | ||
82881 | 3595 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 31 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 03:05:00 PM | 3 | 3X3 | 6018306.03367 | 2097993.65704 | 37.7417167843076 | -122.379285588775 | (37.7417167843076, -122.379285588775) | 10 | 3 | 8 | 58 | 1 | ||
83949 | 27580 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 31 | 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 | ||
84066 | 22080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015965.08966 | 2100473.24055 | 37.7483958378055 | -122.387552815329 | (37.7483958378055, -122.387552815329) | 10 | 3 | 8 | 58 | 1 | ||
84328 | 3645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.382266039154 | (37.7434680683118, -122.382266039154) | 10 | 3 | 8 | 58 | 1 | ||
88529 | 3604 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 40 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018155.72802 | 2098107.78819 | 37.7420218757003 | -122.37981322912 | (37.7420218757003, -122.37981322912) | 10 | 3 | 8 | 58 | 1 | |||
90691 | 3567 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
92662 | 27557 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 8 | 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 |
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) );