trees
34 rows where SiteOrder = 6 and qSpecies_id = 5
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3688 | 189905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016340.3864 | 2098339.29531 | 37.7425572430226 | -122.386106295385 | (37.7425572430226, -122.386106295385) | 10 | 3 | 8 | 58 | 1 | |||
| 8003 | 21791 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4X4 | 6008347.28278 | 2121527.17705 | 37.8057800612465 | -122.415385378175 | (37.8057800612465, -122.415385378175) | 5 | 1 | 10 | 308 | 23 | |||
| 10434 | 189892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 6 | : | Tree | Private 2 | 13 | Width 4ft | 6016806.72009 | 2098324.89991 | 37.7425435148768 | -122.384492832481 | (37.7425435148768, -122.384492832481) | 10 | 3 | 8 | 58 | 1 | |||
| 10873 | 189885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 201 Newhall St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6016834.26905 | 2098267.19561 | 37.7423865939792 | -122.384393557236 | (37.7423865939792, -122.384393557236) | 10 | 3 | 8 | 58 | 1 | |||
| 23322 | 189937 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013275.69539 | 2116164.65668 | 37.7913316253015 | -122.397953334494 | (37.7913316253015, -122.397953334494) | 12 | 2 | 9 | 28855 | 6 | |||
| 32557 | 6849 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.7406745956723 | -122.387598567026 | (37.7406745956723, -122.387598567026) | 10 | 3 | 8 | 58 | 1 | |||
| 33168 | 14912 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017247.98036 | 2098210.14599 | 37.7422528150795 | -122.38295908457 | (37.7422528150795, -122.38295908457) | 10 | 3 | 8 | 58 | 1 | |||
| 34404 | 4917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:50:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
| 38272 | 125985 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | 5 | 1 | 10 | 308 | 23 | |||
| 39895 | 189881 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 6 | : | Tree | Private 2 | 10 | Width 3ft | 6016559.49898 | 2098322.63372 | 37.7425236182725 | -122.385347500499 | (37.7425236182725, -122.385347500499) | 10 | 3 | 8 | 58 | 1 | |||
| 40094 | 2518 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016498.61775 | 2098890.19219 | 37.7440786495081 | -122.385597557904 | (37.7440786495081, -122.385597557904) | 10 | 3 | 8 | 58 | 1 | |||
| 40972 | 16484 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
| 53007 | 106030 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | 12 | 2 | 9 | 28855 | 6 | |||
| 55436 | 126001 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466 | (37.8058471777553, -122.41693886466) | 5 | 1 | 10 | 308 | 23 | |||
| 56857 | 16545 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.387038655827 | (37.7415453861211, -122.387038655827) | 10 | 3 | 8 | 58 | 1 | ||
| 64200 | 189844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017173.06513 | 2098183.08322 | 37.7421743665616 | -122.383216237654 | (37.7421743665616, -122.383216237654) | 10 | 3 | 8 | 58 | 1 | |||
| 71028 | 189931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013267.71842 | 2116267.46362 | 37.7916134647515 | -122.397988149957 | (37.7916134647515, -122.397988149957) | 12 | 2 | 9 | 28855 | 6 | |||
| 102198 | 16504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
| 107370 | 189952 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6014715.63981 | 2116037.408 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | 12 | 2 | 9 | 28855 | 6 | |||
| 114719 | 6650 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | |||
| 119961 | 188486 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6016667.7961 | 2098739.5766 | 37.7436744492327 | -122.385002079878 | (37.7436744492327, -122.385002079878) | 10 | 3 | 8 | 58 | 1 | |||
| 120815 | 93114 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.71109 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | 10 | 3 | 8 | 58 | 1 | |
| 122903 | 125992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008341.11218 | 2121531.47257 | 37.8057915088426 | -122.415407036818 | (37.8057915088426, -122.415407036818) | 5 | 1 | 10 | 308 | 23 | |||
| 123006 | 189856 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 6017223.11391 | 2098220.28067 | 37.7422792688651 | -122.383045771154 | (37.7422792688651, -122.383045771154) | 10 | 3 | 8 | 58 | 1 | |||
| 123202 | 2510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
| 128143 | 16515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 128485 | 97184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013138 | 2116168 | 37.791333135618 | -122.398429995238 | (37.791333135618, -122.398429995238) | 12 | 2 | 9 | 28855 | 6 | |||
| 130611 | 50385 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
| 132813 | 16493 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016616 | 2098292 | 37.7424426300051 | -122.385150000825 | (37.7424426300051, -122.385150000825) | 10 | 3 | 8 | 58 | 1 | ||
| 164547 | 14929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
| 173505 | 119746 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
| 187401 | 119740 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013460.47758 | 2116066.81767 | 37.7910732716747 | -122.397307123936 | (37.7910732716747, -122.397307123936) | 12 | 2 | 9 | 28855 | 6 | ||||
| 192717 | 222909 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004826.79581 | 2109830.90843 | 37.7734665514719 | -122.426735103265 | (37.7734665514719, -122.426735103265) | 7 | 9 | 11 | 28852 | 10 | |||
| 192875 | 2502 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016691.63378 | 2098834.3481 | 37.743935990944 | -122.38492625536 | (37.743935990944, -122.38492625536) | 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) );