Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74726 | 74726 | 206007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991032.21326 | 2097741.2680200003 | 37.739482016692904 | -122.473570049822 | (37.7394820166929, -122.473570049822) | |||
150091 | 150091 | 206006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | |||
157059 | 157059 | 206005 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553001 | (37.7394900683054, -122.47345704553) | |||
66646 | 66646 | 3581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
120289 | 120289 | 96855 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007257.0 | 2097738.0 | 37.740399305054005 | -122.41747145076599 | (37.740399305054, -122.417471450766) | |||
75887 | 75887 | 225065 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006960.17815 | 2097772.4528099997 | 37.740477199257704 | -122.418500188445 | (37.7404771992577, -122.418500188445) | |||
14309 | 14309 | 14975 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943001 | (37.7404872941606, -122.38522858943) | |||
16138 | 16138 | 14974 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016589.22096 | 2097595.13367 | 37.7405276953073 | -122.385194050084 | (37.7405276953073, -122.385194050084) | |||
102430 | 102430 | 96852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007194.0 | 2097789.0 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | |||
84776 | 84776 | 6848 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | |||
112145 | 112145 | 6850 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | ||
128870 | 128870 | 6849 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | |||
14457 | 14457 | 6846 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | |||
163194 | 163194 | 189875 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 15 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6015903.72942 | 2097762.72481 | 37.740949921590904 | -122.387575924289 | (37.7409499215909, -122.387575924289) | |||
46617 | 46617 | 189864 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015974.53489 | 2097767.4819400003 | 37.7409669053009 | -122.387331434622 | (37.7409669053009, -122.387331434622) | |||
157752 | 157752 | 189865 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.38729375121599 | (37.7410155838051, -122.387293751216) | |||
175453 | 175453 | 189874 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6015935.20003 | 2097800.22723 | 37.741054638653004 | -122.387469725156 | (37.741054638653, -122.387469725156) | |||
35702 | 35702 | 189866 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | |||
132324 | 132324 | 189873 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015949.19552 | 2097817.31467 | 37.741102332416204 | -122.38742252514601 | (37.7411023324162, -122.387422525146) | |||
13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
50893 | 50893 | 189872 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6015960.56064 | 2097835.58742 | 37.741153135100205 | -122.387384502698 | (37.7411531351002, -122.387384502698) | |||
5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
92651 | 92651 | 6652 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
107427 | 107427 | 6650 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
110305 | 110305 | 6648 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
112042 | 112042 | 6647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1990 12:00:00 AM | 3 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
119053 | 119053 | 6649 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
120176 | 120176 | 6646 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
123471 | 123471 | 6651 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
88100 | 88100 | 16556 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
99856 | 99856 | 16553 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
140383 | 140383 | 16554 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
146013 | 146013 | 16552 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
165750 | 165750 | 189871 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016028.58203 | 2097927.48174 | 37.741409225160396 | -122.387155715173 | (37.7414092251604, -122.387155715173) | |||
182504 | 182504 | 189867 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016089.46635 | 2097928.7080599996 | 37.7414159637784 | -122.38694528191999 | (37.7414159637784, -122.38694528192) | |||
121655 | 121655 | 16548 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016043.45751 | 2097947.5572599997 | 37.7414651721818 | -122.387105680372 | (37.7414651721818, -122.387105680372) | |||
15837 | 15837 | 16547 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016044.76119 | 2097949.4335 | 37.741470396145104 | -122.387101303489 | (37.7414703961451, -122.387101303489) | |||
15887 | 15887 | 16546 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016053.72523 | 2097961.74591 | 37.7415046998888 | -122.387071167201 | (37.7415046998888, -122.387071167201) | |||
130575 | 130575 | 189868 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016117.80915 | 2097961.55377 | 37.7415077207098 | -122.38684957154899 | (37.7415077207098, -122.386849571549) | |||
13990 | 13990 | 16545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.38703865582701 | (37.7415453861211, -122.387038655827) | ||
69864 | 69864 | 189869 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016127.95859 | 2097976.0947 | 37.7415482090816 | -122.38681549176 | (37.7415482090816, -122.38681549176) | |||
39389 | 39389 | 189870 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016138.74056 | 2097991.9117 | 37.741592236291396 | -122.386779313807 | (37.7415922362914, -122.386779313807) | |||
146502 | 146502 | 189834 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6015429.09406 | 2098017.0802 | 37.7416220281222 | -122.389234809264 | (37.7416220281222, -122.389234809264) | |||
13503 | 13503 | 16543 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.74163887514379 | -122.38696691508999 | (37.7416388751438, -122.38696691509) | ||
23256 | 23256 | 3593 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | ||
67080 | 67080 | 189835 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6015422.83464 | 2098030.46357 | 37.7416584290923 | -122.389257386733 | (37.7416584290923, -122.389257386733) | |||
56798 | 56798 | 189836 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 9 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015406.79125 | 2098034.46628 | 37.741668530275604 | -122.389313139314 | (37.7416685302756, -122.389313139314) | |||
16099 | 16099 | 16541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | |||
161929 | 161929 | 189837 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015387.45837 | 2098059.88528 | 37.7417372537812 | -122.389381761177 | (37.7417372537812, -122.389381761177) | |||
23044 | 23044 | 16540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.741780940152296 | -122.386827291768 | (37.7417809401523, -122.386827291768) | |||
9911 | 9911 | 173732 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015419.0 | 2098106.0 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | ||||
137584 | 137584 | 189851 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 15 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6017359.84801 | 2098072.09609 | 37.741879938402704 | -122.38256267332198 | (37.7418799384027, -122.382562673322) | |||
131495 | 131495 | 189850 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017345.725190001 | 2098082.05897 | 37.7419065142755 | -122.382612199015 | (37.7419065142755, -122.382612199015) | |||
176882 | 176882 | 189838 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 525 Phelps St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6015431.26911 | 2098152.3632900002 | 37.741993608228505 | -122.389236732886 | (37.7419936082285, -122.389236732886) | |||
33190 | 33190 | 189849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.742023306530704 | -122.38283152746 | (37.7420233065307, -122.38283152746) | |||
33099 | 33099 | 189852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017365.88907 | 2098130.81013 | 37.7420414890213 | -122.38254586948999 | (37.7420414890213, -122.38254586949) | |||
157361 | 157361 | 189848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6017264.73109 | 2098137.17538 | 37.7420533780644 | -122.38289608801 | (37.7420533780644, -122.38289608801) | |||
67565 | 67565 | 14919 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
82455 | 82455 | 14908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
116667 | 116667 | 14918 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) | |||
93430 | 93430 | 14909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | |||
60830 | 60830 | 189847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017231.39271 | 2098158.2223400003 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | |||
16483 | 16483 | 16521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.742129650455205 | -122.38628939735099 | (37.7421296504552, -122.386289397351) | |||
131320 | 131320 | 189846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017214.17115 | 2098166.7194 | 37.7421317063069 | -122.383072965771 | (37.7421317063069, -122.383072965771) | |||
127219 | 127219 | 14910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017317.95316 | 2098168.33206 | 37.7421418684871 | -122.38271422871999 | (37.7421418684871, -122.38271422872) | |||
32657 | 32657 | 189845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017192.34248 | 2098175.05438 | 37.7421533862633 | -122.383149023221 | (37.7421533862633, -122.383149023221) | |||
184302 | 184302 | 189844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017173.06513 | 2098183.08322 | 37.742174366561606 | -122.383216237654 | (37.7421743665616, -122.383216237654) | |||
15226 | 15226 | 16522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016298.51131 | 2098203.0123900003 | 37.7421807202532 | -122.386241589372 | (37.7421807202532, -122.386241589372) | |||
173588 | 173588 | 189854 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6017283.71117 | 2098187.47887 | 37.742192549946104 | -122.38283396012599 | (37.7421925499461, -122.382833960126) | |||
157640 | 157640 | 189843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017155.58292 | 2098191.33075 | 37.742196046505 | -122.38327726024599 | (37.742196046505, -122.383277260246) | |||
113999 | 113999 | 14911 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | |||
147716 | 147716 | 189842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017136.0861599995 | 2098201.14709 | 37.7422219227174 | -122.383345357813 | (37.7422219227174, -122.383345357813) | |||
15063 | 15063 | 16523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016311.2033400005 | 2098218.94031 | 37.742225157565606 | -122.386198814044 | (37.7422251575656, -122.386198814044) | |||
38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
26487 | 26487 | 189910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.742244189916704 | -122.386410241063 | (37.7422441899167, -122.386410241063) | |||
158918 | 158918 | 189855 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017245.40272 | 2098209.38961 | 37.7422505957884 | -122.382967944715 | (37.7422505957884, -122.382967944715) | |||
160768 | 160768 | 189840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017094.37686 | 2098212.93845 | 37.7422519942486 | -122.383490397763 | (37.7422519942486, -122.383490397763) | |||
124746 | 124746 | 14912 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017247.980359999 | 2098210.14599 | 37.742252815079496 | -122.38295908456999 | (37.7422528150795, -122.38295908457) | |||
22318 | 22318 | 3611 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.2961099995 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | ||
132013 | 132013 | 189839 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.38356026519699 | (37.7422631836031, -122.383560265197) | |||
15597 | 15597 | 16524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016323.686869999 | 2098236.56346 | 37.7422742380775 | -122.386156877755 | (37.7422742380775, -122.386156877755) | |||
156617 | 156617 | 189856 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017223.11391 | 2098220.2806700002 | 37.742279268865104 | -122.383045771154 | (37.7422792688651, -122.383045771154) | |||
79625 | 79625 | 14913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | |||
78717 | 78717 | 4915 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
79676 | 79676 | 4925 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
85510 | 85510 | 4912 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
102536 | 102536 | 4922 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
113730 | 113730 | 4923 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
117916 | 117916 | 4913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
122367 | 122367 | 4918 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
124291 | 124291 | 4926 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
125620 | 125620 | 4920 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:54:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
127870 | 127870 | 4917 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:50:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
140926 | 140926 | 4919 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
141444 | 141444 | 4914 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
143020 | 143020 | 4916 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
163101 | 163101 | 189909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 3ft | 6016264.27306 | 2098246.63974 | 37.7422986168968 | -122.386363016745 | (37.7422986168968, -122.386363016745) | |||
24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
103848 | 103848 | 14914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.742305197314295 | -122.383103612647 | (37.7423051973143, -122.383103612647) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");