trees
3,709 rows where qSpecies_id = 9 sorted by Neighborhoods (old)
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 | |||||||||||||
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 | |||
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 | |||
6952 | 264732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1965 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012227 | 2095019 | 37.7332118929398 | -122.40009613746 | (37.7332118929398, -122.40009613746) | 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 | |||
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 | |||
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 | ||||
15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 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 | |||
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 | ||
17950 | 79191 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1750 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6011751.02985 | 2092731.77406 | 37.7269050958844 | -122.401581006276 | (37.7269050958844, -122.401581006276) | 10 | 3 | 8 | 58 | 1 | |||
19850 | 194218 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 6013410.02884 | 2090031.5953 | 37.7195833814573 | -122.395656735769 | (37.7195833814573, -122.395656735769) | 10 | 3 | 8 | 58 | 1 | ||||
20943 | 54784 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50703 | 6012788.79472 | 2087552.61474 | 37.7127420182918 | -122.397630353754 | (37.7127420182918, -122.397630353754) | 10 | 3 | 8 | 309 | 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 | ||
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 | |||
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 | ||
34785 | 22523 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6600 03rd St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012847.5284056 | 2089784.7633559 | 37.7188743244909 | -122.397583806576 | (37.7188743244909, -122.397583806576) | 10 | 3 | 8 | 58 | 1 | |||
35082 | 65502 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 144 Venus St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1989 12:00:00 AM | 11 | Permit Number 28386 | 6012831.84072 | 2094190.06058 | 37.7309695018215 | -122.397946895354 | (37.7309695018215, -122.397946895354) | 10 | 3 | 8 | 58 | 1 | ||
35295 | 22437 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6025 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013597.3212 | 2091386.3105 | 37.7233135750036 | -122.39510416905 | (37.7233135750036, -122.39510416905) | 10 | 3 | 8 | 58 | 1 | |||
36260 | 194193 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
52842 | 22433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6000 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1992 12:00:00 AM | 3 | 3X3 | 6013569.5341 | 2091525.6902 | 37.7236947383504 | -122.395209983132 | (37.7236947383504, -122.395209983132) | 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 | ||
54899 | 194214 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1030 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013004.48576 | 2089699.06872 | 37.7186477627738 | -122.397035257987 | (37.7186477627738, -122.397035257987) | 10 | 3 | 8 | 58 | 1 | |||
55741 | 104461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601X Kansas St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 10 | 3 | 8 | 58 | 1 | |||
57830 | 67676 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1970 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012165.49957843 | 2093485.91293956 | 37.7289989246829 | -122.400201126902 | (37.7289989246829, -122.400201126902) | 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 | ||
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 | |||
60988 | 194221 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012968.46094 | 2090076.8184 | 37.7196829822717 | -122.397186255957 | (37.7196829822717, -122.397186255957) | 10 | 3 | 8 | 58 | 1 | |||
62809 | 194219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013415.40609 | 2090027.00023 | 37.7195710634281 | -122.395637826651 | (37.7195710634281, -122.395637826651) | 10 | 3 | 8 | 58 | 1 | ||||
65335 | 22455 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 6146X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/1996 12:00:00 AM | 12 | 3X3 | 6013520.36476 | 2091382.05626 | 37.7232976138509 | -122.395369896984 | (37.7232976138509, -122.395369896984) | 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 | ||
74424 | 22518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6518 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6012926.62983 | 2089906.00338 | 37.7192116295963 | -122.397318879858 | (37.7192116295963, -122.397318879858) | 10 | 3 | 8 | 58 | 1 | |||
76952 | 194195 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Pomona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014203.67115 | 2094680.19203 | 37.7323916096872 | -122.393238495663 | (37.7323916096872, -122.393238495663) | 10 | 3 | 8 | 58 | 1 | |||
77445 | 85384 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1970 Carroll Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012142.9 | 2093507.8 | 37.7290577618583 | -122.40028079247 | (37.7290577618583, -122.40028079247) | 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 | |||
79435 | 22512 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013020.80961 | 2090093.5041 | 37.719731712041 | -122.397006473368 | (37.719731712041, -122.397006473368) | 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 | |||
79849 | 85381 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1970 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012142.9 | 2093507.8 | 37.7290577618583 | -122.40028079247 | (37.7290577618583, -122.40028079247) | 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 | |||
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 | ||
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 | ||
84720 | 85383 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1970 Carroll Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012142.9 | 2093507.8 | 37.7290577618583 | -122.40028079247 | (37.7290577618583, -122.40028079247) | 10 | 3 | 8 | 58 | 1 | |||
85424 | 22513 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013017.34088 | 2090082.06317 | 37.7197001044495 | -122.39701766186 | (37.7197001044495, -122.39701766186) | 10 | 3 | 8 | 58 | 1 | |||
85570 | 194220 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6524 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012914.00103 | 2089890.00071 | 37.7191669863524 | -122.397361411494 | (37.7191669863524, -122.397361411494) | 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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
106687 | 194217 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6013395.77535 | 2090042.77857 | 37.7196132956026 | -122.395706788434 | (37.7196132956026, -122.395706788434) | 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 | |||
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 | ||
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 | |||
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 | ||
117765 | 31670 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 305 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35178 | 6012134.6965622 | 2087196.99456235 | 37.7117291112295 | -122.399866184073 | (37.7117291112295, -122.399866184073) | 10 | 3 | 8 | 309 | 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 | ||
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 | |||
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 | |||
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 | ||
129712 | 111972 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 240 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 1 | 3x3 | 6012967.33594 | 2095411.30766 | 37.7343303393552 | -122.39756408274 | (37.7343303393552, -122.39756408274) | 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 | ||
130480 | 194223 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012938.89979 | 2090098.87174 | 37.7197418905657 | -122.397289984657 | (37.7197418905657, -122.397289984657) | 10 | 3 | 8 | 58 | 1 | |||
132901 | 194216 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6013384.67345 | 2090050.69381 | 37.7196344116892 | -122.395745718284 | (37.7196344116892, -122.395745718284) | 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 | |||
134856 | 18557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1700X Quesada Ave | 12 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014589.42489 | 2095117.74479 | 37.7336144637386 | -122.391935430178 | (37.7336144637386, -122.391935430178) | 10 | 3 | 8 | 58 | 1 | |||
136827 | 194192 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 10 | 3 | 8 | 58 | 1 | |||
138217 | 22519 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 6520X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6012970.43876 | 2089969.7044 | 37.719388978809 | -122.397171912348 | (37.719388978809, -122.397171912348) | 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 | |||
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 | ||
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 | |||
144619 | 22376 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5538 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6014077.5103 | 2092853.4647 | 37.7273687774645 | -122.393546865436 | (37.7273687774645, -122.393546865436) | 10 | 3 | 8 | 58 | 1 | |||
145738 | 12932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6540X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012937.6533 | 2089925.98182 | 37.7192671001169 | -122.39728217588 | (37.7192671001169, -122.39728217588) | 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 | ||
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 | ||
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 |
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) );