trees
3,709 rows where qSpecies_id = 9 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
16339 | 39482 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
17767 | 35283 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
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 | ||
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 | ||
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 | ||
105856 | 3574 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 9 | 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 | ||
146341 | 3568 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | 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 | ||
178553 | 3571 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 6 | 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 | ||
84135 | 3566 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.7402294045724 | -122.377152086609 | (37.7402294045724, -122.377152086609) | 10 | 3 | 8 | 58 | 1 | ||
84537 | 3565 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.377214841296 | (37.740264715549, -122.377214841296) | 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 | ||||
150545 | 3564 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.7402990714478 | -122.377276992562 | (37.7402990714478, -122.377276992562) | 10 | 3 | 8 | 58 | 1 | ||
23789 | 3563 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.377336126574 | (37.7403324731777, -122.377336126574) | 10 | 3 | 8 | 58 | 1 | ||
48057 | 3562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.377394053707 | (37.7403663524293, -122.377394053707) | 10 | 3 | 8 | 58 | 1 | ||
149621 | 3555 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018831.8 | 2097475.1 | 37.7403219094469 | -122.377431668566 | (37.7403219094469, -122.377431668566) | 10 | 3 | 8 | 58 | 1 | ||
175871 | 3560 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | 10 | 3 | 8 | 58 | 1 | ||
6307 | 83045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | 10 | 3 | 8 | 58 | 1 | |||
36534 | 3559 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | 10 | 3 | 8 | 58 | 1 | ||
13702 | 83044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018777.54715 | 2097643.31156 | 37.7407807960029 | -122.377630926146 | (37.7407807960029, -122.377630926146) | 10 | 3 | 8 | 58 | 1 | |||
32116 | 3557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.22153 | 2097553.75967 | 37.7405338394733 | -122.377691534151 | (37.7405338394733, -122.377691534151) | 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 | |||
130025 | 3550 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | 10 | 3 | 8 | 58 | 1 | ||
60263 | 41526 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | 10 | 3 | 8 | 58 | 1 | |||
100457 | 1984 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 106 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 3 | 3X4 | 6017854.9793307 | 2094779.8205714 | 37.732867343787 | -122.380621861717 | (37.732867343787, -122.380621861717) | 10 | 3 | 8 | 58 | 1 | ||
165754 | 1980 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 96 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017818.3743209 | 2094812.8777717 | 37.7329560922326 | -122.380750713036 | (37.7329560922326, -122.380750713036) | 10 | 3 | 8 | 58 | 1 | ||
188529 | 121343 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 399X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
190890 | 121354 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 399X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
59776 | 1967 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017714.6010769 | 2094983.7665226 | 37.7334195913803 | -122.381121365124 | (37.7334195913803, -122.381121365124) | 10 | 3 | 8 | 58 | 1 | ||
151694 | 1964 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 45 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017685.4326556 | 2095014.8991764 | 37.7335034653707 | -122.381224373553 | (37.7335034653707, -122.381224373553) | 10 | 3 | 8 | 58 | 1 | ||
181971 | 1958 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 31 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017652.9680682 | 2095074.2258741 | 37.7336645725809 | -122.381340737954 | (37.7336645725809, -122.381340737954) | 10 | 3 | 8 | 58 | 1 | ||
51618 | 1962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 36 Bertha Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017618.4307655 | 2095033.1830576 | 37.7335499703731 | -122.381457291596 | (37.7335499703731, -122.381457291596) | 10 | 3 | 8 | 58 | 1 | ||
168148 | 1957 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 28 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017599.7808961 | 2095067.264352 | 37.7336425212053 | -122.381524139501 | (37.7336425212053, -122.381524139501) | 10 | 3 | 8 | 58 | 1 | ||
141615 | 1951 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 22 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.7337624844256 | -122.38155350563 | (37.7337624844256, -122.38155350563) | 10 | 3 | 8 | 58 | 1 | ||
126692 | 51293 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1211 Shafter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47665 | 6016968.484021 | 2092614.87789536 | 37.726873876443 | -122.383536069104 | (37.726873876443, -122.383536069104) | 10 | 3 | 8 | 58 | 1 | |||
157355 | 199980 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1211 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016959.5373 | 2092619.407 | 37.7268858179819 | -122.383567313185 | (37.7268858179819, -122.383567313185) | 10 | 3 | 8 | 58 | 1 | |||
114525 | 10604 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.86457 | 2095475.59177 | 37.7347311744022 | -122.383588632512 | (37.7347311744022, -122.383588632512) | 10 | 3 | 8 | 58 | 1 | ||
190658 | 102732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1217 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6016939.1559 | 2092633.1782 | 37.7269225044661 | -122.383638730259 | (37.7269225044661, -122.383638730259) | 10 | 3 | 8 | 58 | 1 | |||
38488 | 51294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1217 Shafter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47666 | 6016937.80385774 | 2092637.74842389 | 37.7269349786738 | -122.383643722332 | (37.7269349786738, -122.383643722332) | 10 | 3 | 8 | 58 | 1 | |||
122685 | 194229 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 7 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6016979.33181 | 2095396.89704 | 37.7345133514147 | -122.383692175976 | (37.7345133514147, -122.383692175976) | 10 | 3 | 8 | 58 | 1 | |||
39036 | 194228 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6016962.87933 | 2095412.73629 | 37.7345559334103 | -122.38375016066 | (37.7345559334103, -122.38375016066) | 10 | 3 | 8 | 58 | 1 | |||
159481 | 3726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016987.22702 | 2098921.28419 | 37.744191044988 | -122.383910204019 | (37.744191044988, -122.383910204019) | 10 | 3 | 8 | 58 | 1 | |||
151866 | 194226 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Jakey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6016841.98922 | 2095417.85433 | 37.7345633033443 | -122.384168478511 | (37.7345633033443, -122.384168478511) | 10 | 3 | 8 | 58 | 1 | |||
24701 | 194230 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 58 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6016826.40406 | 2095640.34928 | 37.7351733683505 | -122.384237852219 | (37.7351733683505, -122.384237852219) | 10 | 3 | 8 | 58 | 1 | |||
168638 | 194227 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 8 Jakey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6016817.60054 | 2095485.74545 | 37.7347483703482 | -122.384257525772 | (37.7347483703482, -122.384257525772) | 10 | 3 | 8 | 58 | 1 | |||
52467 | 194231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6016795.73668 | 2095634.4055 | 37.7351553522317 | -122.384343467669 | (37.7351553522317, -122.384343467669) | 10 | 3 | 8 | 58 | 1 | |||
83326 | 194225 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Jakey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6016755.26705 | 2095536.04747 | 37.7348830429134 | -122.384476538576 | (37.7348830429134, -122.384476538576) | 10 | 3 | 8 | 58 | 1 | |||
133701 | 194224 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 11 Jakey Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6016749.98334 | 2095555.73275 | 37.7349368025769 | -122.384496177064 | (37.7349368025769, -122.384496177064) | 10 | 3 | 8 | 58 | 1 | |||
179887 | 194232 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 70 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6016747.54449 | 2095620.76311 | 37.7351152280806 | -122.38450913719 | (37.7351152280806, -122.38450913719) | 10 | 3 | 8 | 58 | 1 | |||
11542 | 194238 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6016710.45664 | 2095786.72783 | 37.7355688829898 | -122.384648921526 | (37.7355688829898, -122.384648921526) | 10 | 3 | 8 | 58 | 1 | |||
106856 | 194237 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 11 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6016697.0495 | 2095760.45578 | 37.735496003732 | -122.384693446039 | (37.735496003732, -122.384693446039) | 10 | 3 | 8 | 58 | 1 | |||
139464 | 194233 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6016686.67059 | 2095602.00775 | 37.7350603631446 | -122.384718296107 | (37.7350603631446, -122.384718296107) | 10 | 3 | 8 | 58 | 1 | |||
104805 | 194236 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6016647.59382 | 2095743.55851 | 37.7354468719595 | -122.384863257848 | (37.7354468719595, -122.384863257848) | 10 | 3 | 8 | 58 | 1 | |||
77732 | 194235 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6016602.67648 | 2095728.95529 | 37.7354042899791 | -122.385017538329 | (37.7354042899791, -122.385017538329) | 10 | 3 | 8 | 58 | 1 | |||
170810 | 194234 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 21 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6016584.85791 | 2095721.56039 | 37.7353829994301 | -122.385078629298 | (37.7353829994301, -122.385078629298) | 10 | 3 | 8 | 58 | 1 | |||
73931 | 3554 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201X Cargo Way | 64 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | 10 | 3 | 8 | 58 | 1 | ||
79438 | 194241 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4 Mabrey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6016531.12407 | 2095935.7497 | 37.7359681478157 | -122.385279329202 | (37.7359681478157, -122.385279329202) | 10 | 3 | 8 | 58 | 1 | |||
107369 | 3707 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016577.53961 | 2099225.88923 | 37.7450047713688 | -122.385348049088 | (37.7450047713688, -122.385348049088) | 10 | 3 | 8 | 58 | 1 | ||
96506 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Newhall St | 1 | Front Yard : Yard | Tree | Private 2 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.7432615694897 | -122.385402196424 | (37.7432615694897, -122.385402196424) | 10 | 3 | 8 | 58 | 1 | |||
162618 | 13318 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 11 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/09/1992 12:00:00 AM | 12 | 3X3 | 6016491.98013 | 2095896.26802 | 37.7358575734588 | -122.385411916251 | (37.7358575734588, -122.385411916251) | 10 | 3 | 8 | 58 | 1 | ||
90118 | 194240 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Mabrey Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6016449.38039 | 2095875.60267 | 37.7357984736048 | -122.385557761994 | (37.7357984736048, -122.385557761994) | 10 | 3 | 8 | 58 | 1 | |||
93472 | 13320 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 16 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/09/1992 12:00:00 AM | 6 | 3X3 | 6016446.48412 | 2095922.18028 | 37.7359262061134 | -122.385571020705 | (37.7359262061134, -122.385571020705) | 10 | 3 | 8 | 58 | 1 | ||
174925 | 194239 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Mabrey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6016431.07733 | 2095866.9452 | 37.7357736892058 | -122.385620440254 | (37.7357736892058, -122.385620440254) | 10 | 3 | 8 | 58 | 1 | |||
2096 | 3697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016390.48971 | 2099364.75407 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | 10 | 3 | 8 | 58 | 1 | |||
108650 | 12193 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1465 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016272.6778818 | 2095480.4561364 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | 10 | 3 | 8 | 58 | 1 | |||
50411 | 200525 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016241.3617 | 2095551.4547 | 37.7348969165843 | -122.386254379093 | (37.7348969165843, -122.386254379093) | 10 | 3 | 8 | 58 | 1 | |||
43038 | 194194 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1888 Illinois St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6016264.99223 | 2100427.37243 | 37.7482865000228 | -122.386512551535 | (37.7482865000228, -122.386512551535) | 10 | 3 | 8 | 58 | 1 | |||
127202 | 12216 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1523 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1992 12:00:00 AM | 15 | 3X3 | 6015935.5625 | 2095820.8342 | 37.735619647499 | -122.387330428498 | (37.735619647499, -122.387330428498) | 10 | 3 | 8 | 58 | 1 | ||
120372 | 64528 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1450 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25410 | 6015863.28704 | 2094893.11504234 | 37.7330683144881 | -122.387515613747 | (37.7330683144881, -122.387515613747) | 10 | 3 | 8 | 58 | 1 | ||
165285 | 96731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1504 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015860.59929 | 2096653.48415 | 37.7379017837359 | -122.38764768211 | (37.7379017837359, -122.38764768211) | 10 | 3 | 8 | 58 | 1 | |||
143377 | 22114 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3650X 03rd St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 5X5 | 6015872.24057 | 2098764.87252 | 37.7436998694469 | -122.38775470774 | (37.7436998694469, -122.38775470774) | 10 | 3 | 8 | 58 | 1 | |||
158871 | 194138 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 Illinois St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6015994.24024 | 2105456.78042 | 37.7620812009176 | -122.387799686412 | (37.7620812009176, -122.387799686412) | 10 | 3 | 8 | 28856 | 29 | ||||
11031 | 194139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6015990.60538 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | 10 | 3 | 8 | 28856 | 29 | ||||
183212 | 194140 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 Illinois St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6015990.70284 | 2105517.86766 | 37.7622487374207 | -122.387816183567 | (37.7622487374207, -122.387816183567) | 10 | 3 | 8 | 28856 | 29 | ||||
13589 | 74272 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015960.78285 | 2105386.23771 | 37.7618856523157 | -122.387910481099 | (37.7618856523157, -122.387910481099) | 10 | 3 | 8 | 28856 | 29 | |||
4553 | 74059 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015912.53475 | 2105383.55959 | 37.7618756257676 | -122.388077166837 | (37.7618756257676, -122.388077166837) | 10 | 3 | 8 | 28856 | 29 | |||
4203 | 72834 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015894.43243 | 2105382.09889 | 37.7618706120468 | -122.388139674229 | (37.7618706120468, -122.388139674229) | 10 | 3 | 8 | 28856 | 29 | |||
188345 | 22198 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4049 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6015622.4674 | 2097608.2349 | 37.7405101410632 | -122.388537652185 | (37.7405101410632, -122.388537652185) | 10 | 3 | 8 | 58 | 1 | |||
16959 | 71390 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1530 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015584.85469 | 2096508.00591 | 37.7374870523836 | -122.388590922526 | (37.7374870523836, -122.388590922526) | 10 | 3 | 8 | 58 | 1 | |||
83483 | 55069 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1410 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10963 | 6015495.8002 | 2094978.5728 | 37.7332826032428 | -122.388792087955 | (37.7332826032428, -122.388792087955) | 10 | 3 | 8 | 58 | 1 | ||
159864 | 194136 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 51 | Front Yard : Yard | Tree | Private 2 | 9 | 6015363.67927 | 2102425.5673 | 37.7537231868853 | -122.389768841963 | (37.7537231868853, -122.389768841963) | 10 | 3 | 8 | 28856 | 29 | ||||
103643 | 194137 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 52 | Front Yard : Yard | Tree | Private 2 | 7 | 6015362.68251 | 2102417.32718 | 37.7537005059858 | -122.389771713504 | (37.7537005059858, -122.389771713504) | 10 | 3 | 8 | 28856 | 29 | ||||
14081 | 194133 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 47 | Front Yard : Yard | Tree | Private 2 | 4 | 6015360.93697 | 2102437.87419 | 37.7537568269303 | -122.389779185082 | (37.7537568269303, -122.389779185082) | 10 | 3 | 8 | 28856 | 29 | ||||
21341 | 194135 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 50 | Front Yard : Yard | Tree | Private 2 | 7 | 6015359.62578 | 2102424.0826 | 37.7537188854327 | -122.38978275627 | (37.7537188854327, -122.38978275627) | 10 | 3 | 8 | 28856 | 29 | ||||
69532 | 194132 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 46 | Front Yard : Yard | Tree | Private 2 | 5 | 6015356.8182 | 2102444.39788 | 37.7537745112003 | -122.389793884481 | (37.7537745112003, -122.389793884481) | 10 | 3 | 8 | 28856 | 29 | ||||
172778 | 194134 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 48 | Front Yard : Yard | Tree | Private 2 | 5 | 6015354.20873 | 2102436.42156 | 37.7537524652077 | -122.389802351607 | (37.7537524652077, -122.389802351607) | 10 | 3 | 8 | 28856 | 29 | ||||
161296 | 38631 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1575 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40565 | 6015036.874 | 2094048.9037 | 37.730704473021 | -122.390313804197 | (37.730704473021, -122.390313804197) | 10 | 3 | 8 | 58 | 1 | |
65782 | 194130 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1278 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6015031.01139 | 2102620.78867 | 37.7542407701151 | -122.39093293521 | (37.7542407701151, -122.39093293521) | 10 | 3 | 8 | 28856 | 29 | |||
16998 | 109968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 2 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
42155 | 109967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 1 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
158865 | 194131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1310 Indiana St | 4 | : Yard | Tree | Private 2 | 37 | 6014985.85621 | 2102536.59701 | 37.754007092062 | -122.391083210127 | (37.754007092062, -122.391083210127) | 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) );