trees
44 rows where Supervisor Districts = 4 and qSpecies_id = 5 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
11562 | 206018 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | 1 | 8 | 4 | 59 | 40 | |||
21860 | 206006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | 1 | 8 | 4 | 29491 | 40 | |||
33818 | 206007 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991032.21326 | 2097741.26802 | 37.7394820166929 | -122.473570049822 | (37.7394820166929, -122.473570049822) | 1 | 8 | 4 | 29491 | 40 | |||
47941 | 218315 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.466425098064 | (37.7455947140337, -122.466425098064) | 1 | 8 | 4 | 29491 | 40 | |||
50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
76986 | 205989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.463057021885 | (37.744370734026, -122.463057021885) | 1 | 8 | 4 | 29491 | 40 | |||
91647 | 205994 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994253.11993 | 2101023.44894 | 37.7486800649323 | -122.462671676761 | (37.7486800649323, -122.462671676761) | 1 | 8 | 4 | 29491 | 40 | |||
110855 | 114592 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 70 LOMITA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991433 | 2104626 | 37.7584089066312 | -122.472686161822 | (37.7584089066312, -122.472686161822) | 1 | 8 | 4 | 56 | 12 | |||
111983 | 206019 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.7450917681756 | -122.460627918846 | (37.7450917681756, -122.460627918846) | 1 | 8 | 4 | 59 | 40 | |||
120839 | 206020 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.461887948175 | (37.7487957447457, -122.461887948175) | 1 | 8 | 4 | 29491 | 40 | |||
129163 | 205988 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1469 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993333.43827 | 2105504.18267 | 37.7609299931406 | -122.466177475131 | (37.7609299931406, -122.466177475131) | 1 | 8 | 4 | 56 | 12 | |||
145696 | 206010 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.474004761412 | (37.7394635005399, -122.474004761412) | 1 | 8 | 4 | 29491 | 40 | |||
149591 | 206002 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.7580697533422 | -122.471665566332 | (37.7580697533422, -122.471665566332) | 1 | 8 | 4 | 56 | 12 | |||
159563 | 205993 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994259.77922 | 2101011.29176 | 37.7486470679175 | -122.462647767404 | (37.7486470679175, -122.462647767404) | 1 | 8 | 4 | 29491 | 40 | |||
161171 | 113383 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 146 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5994461 | 2101055 | 37.7487786662853 | -122.461955122224 | (37.7487786662853, -122.461955122224) | 1 | 8 | 4 | 29491 | 40 | |||
164683 | 112815 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10 LOMITA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991472 | 2104830 | 37.7589712942358 | -122.472566156736 | (37.7589712942358, -122.472566156736) | 1 | 8 | 4 | 56 | 12 | ||||
164831 | 206009 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990946.44352 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | 1 | 8 | 4 | 29491 | 40 | |||
170609 | 206008 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990990.06403 | 2097739.22497 | 37.7394739659536 | -122.473715632987 | (37.7394739659536, -122.473715632987) | 1 | 8 | 4 | 29491 | 40 | |||
176911 | 206011 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.7394610849722 | -122.474090278863 | (37.7394610849722, -122.474090278863) | 1 | 8 | 4 | 29491 | 40 | |||
182568 | 206012 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990870.16608 | 2097736.47672 | 37.7394594751618 | -122.474129983014 | (37.7394594751618, -122.474129983014) | 1 | 8 | 4 | 29491 | 40 | |||
188809 | 218314 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | 1 | 8 | 4 | 29491 | 40 | |||
191561 | 206003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.49788 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | 1 | 8 | 4 | 56 | 12 | |||
6377 | 82142 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
38322 | 206016 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | |||
46538 | 205998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998781.20203 | 2096512.57724 | 37.7365540408212 | -122.446689155601 | (37.7365540408212, -122.446689155601) | 9 | 7 | 4 | 59 | 40 | |||
47524 | 205997 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998801.07075 | 2096511.79706 | 37.7365530335853 | -122.446620405109 | (37.7365530335853, -122.446620405109) | 9 | 7 | 4 | 59 | 40 | |||
63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
71731 | 205992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993371.39802 | 2093686.31414 | 37.728483309841 | -122.465187784693 | (37.728483309841, -122.465187784693) | 9 | 8 | 4 | 59 | 40 | |||
114437 | 206015 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.456394837862 | (37.7296789783055, -122.456394837862) | 9 | 7 | 4 | 28861 | 40 | |||
115939 | 82092 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
128316 | 206000 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997987.32263 | 2094070.28162 | 37.7298026971396 | -122.449258019538 | (37.7298026971396, -122.449258019538) | 9 | 7 | 4 | 28861 | 40 | ||||
146949 | 82141 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
149414 | 205991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.7284735045328 | -122.465126926677 | (37.7284735045328, -122.465126926677) | 9 | 8 | 4 | 59 | 40 | |||
150580 | 82143 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
152645 | 205995 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998862.6525 | 2096533.61775 | 37.7366164654663 | -122.446409060855 | (37.7366164654663, -122.446409060855) | 9 | 7 | 4 | 59 | 40 | |||
159417 | 57469 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.468312338233 | (37.7263014049972, -122.468312338233) | 9 | 8 | 4 | 59 | 40 | ||
169891 | 205990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993405.09676 | 2093676.51676 | 37.7284583518695 | -122.46507057606 | (37.7284583518695, -122.46507057606) | 9 | 8 | 4 | 59 | 40 | |||
174999 | 205996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998822.4881 | 2096514.65172 | 37.7365620951723 | -122.446546561796 | (37.7365620951723, -122.446546561796) | 9 | 7 | 4 | 59 | 40 | |||
179167 | 206017 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 59 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996580.00391 | 2094034.75678 | 37.7296245567167 | -122.454120687124 | (37.7296245567167, -122.454120687124) | 9 | 7 | 4 | 28861 | 40 |
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) );