trees
55 rows where SiteOrder = 5 and qSpecies_id = 5 sorted by Police Districts
This data as json, CSV (advanced)
qLegalStatus_id ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12712 | 19967 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
49612 | 125976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | 5 | 1 | 1 | 28858 | 32 | |||
67416 | 125984 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | 5 | 1 | 10 | 308 | 23 | |||
72985 | 21790 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6008342.51156 | 2121554.8602 | 37.8058558040212 | -122.415403850799 | (37.8058558040212, -122.415403850799) | 5 | 1 | 10 | 308 | 23 | |||
85002 | 125991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008338.82398 | 2121554.95666 | 37.8058558616148 | -122.415416619107 | (37.8058558616148, -122.415416619107) | 5 | 1 | 10 | 308 | 23 | |||
98799 | 126000 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007902.73328 | 2121542.33791 | 37.8057966934257 | -122.416924887385 | (37.8057966934257, -122.416924887385) | 5 | 1 | 10 | 308 | 23 | |||
161042 | 101045 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
6962 | 189948 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6014781.22378 | 2116142.62721 | 37.7913548700732 | -122.392742658052 | (37.7913548700732, -122.392742658052) | 12 | 2 | 9 | 28855 | 6 | |||
14738 | 103343 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
60927 | 189962 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | 8 | 2 | 9 | 28853 | 34 | |||
80077 | 106029 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 14 | 3x3 | Permit Number 770222 | 6014636.89755 | 2115962.51686 | 37.7908523118267 | -122.393229418798 | (37.7908523118267, -122.393229418798) | 12 | 2 | 9 | 28855 | 6 | |
89800 | 188471 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.415501579828 | (37.7711845613454, -122.415501579828) | 8 | 2 | 9 | 28853 | 19 | |||
101550 | 119745 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
105981 | 106036 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||
113987 | 189951 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6014728.34644 | 2116051.81938 | 37.7911025958469 | -122.392919257911 | (37.7911025958469, -122.392919257911) | 12 | 2 | 9 | 28855 | 6 | |||
124477 | 189963 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010349.36768 | 2108372.96344 | 37.7697740574441 | -122.40752882731 | (37.7697740574441, -122.40752882731) | 8 | 2 | 9 | 28853 | 34 | |||
136547 | 22889 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
144602 | 189930 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013282.15015 | 2116252.99602 | 37.7915745438725 | -122.397937200642 | (37.7915745438725, -122.397937200642) | 12 | 2 | 9 | 28855 | 6 | |||
156238 | 189936 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013261.48411 | 2116177.89779 | 37.7913671907995 | -122.398003434816 | (37.7913671907995, -122.398003434816) | 12 | 2 | 9 | 28855 | 6 | |||
158873 | 97183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
186270 | 119739 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6013469.82728 | 2116055.87494 | 37.7910437460335 | -122.397274006392 | (37.7910437460335, -122.397274006392) | 12 | 2 | 9 | 28855 | 6 | ||||
5811 | 2517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | 10 | 3 | 8 | 58 | 1 | |||
16420 | 189843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017155.58292 | 2098191.33075 | 37.742196046505 | -122.383277260246 | (37.742196046505, -122.383277260246) | 10 | 3 | 8 | 58 | 1 | |||
19053 | 153989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016386.30028 | 2098368.17483 | 37.7426390813321 | -122.385949549827 | (37.7426390813321, -122.385949549827) | 10 | 3 | 8 | 58 | 1 | |||
24789 | 188485 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016660.6215 | 2098754.7402 | 37.7437156885266 | -122.385027944407 | (37.7437156885266, -122.385027944407) | 10 | 3 | 8 | 58 | 1 | |||
35835 | 2509 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
42634 | 2501 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016709.08958 | 2098828.16093 | 37.7439199677279 | -122.384865465686 | (37.7439199677279, -122.384865465686) | 10 | 3 | 8 | 58 | 1 | |||
43361 | 14928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
52927 | 17415 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.7365975859977 | -122.395366549732 | (37.7365975859977, -122.395366549732) | 10 | 3 | 8 | 58 | 1 | |||
65447 | 93113 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.49318 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | 10 | 3 | 8 | 58 | 1 | |
72425 | 189898 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6016641.64949 | 2098357.67933 | 37.7426243909147 | -122.385065886799 | (37.7426243909147, -122.385065886799) | 10 | 3 | 8 | 58 | 1 | |||
73224 | 16514 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016343.32243 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | 10 | 3 | 8 | 58 | 1 | |||
73481 | 6848 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 5 | 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 | |||
73656 | 16503 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 5 | 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 | |||
77795 | 189855 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6017245.40272 | 2098209.38961 | 37.7422505957884 | -122.382967944715 | (37.7422505957884, -122.382967944715) | 10 | 3 | 8 | 58 | 1 | |||
87736 | 16483 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
102811 | 189880 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 5 | : | Tree | Private 2 | 7 | Width 3ft | 6016536.79452 | 2098327.43911 | 37.742535556771 | -122.385426341355 | (37.742535556771, -122.385426341355) | 10 | 3 | 8 | 58 | 1 | |||
111049 | 189870 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 5 | : | Tree | Private 2 | 13 | Width 3ft | 6016138.74056 | 2097991.9117 | 37.7415922362914 | -122.386779313807 | (37.7415922362914, -122.386779313807) | 10 | 3 | 8 | 58 | 1 | |||
129987 | 16525 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016336.59711 | 2098251.27907 | 37.7423153586798 | -122.386113263318 | (37.7423153586798, -122.386113263318) | 10 | 3 | 8 | 58 | 1 | |||
143317 | 189891 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6016826.79146 | 2098321.83879 | 37.7425362195639 | -122.384423217764 | (37.7425362195639, -122.384423217764) | 10 | 3 | 8 | 58 | 1 | |||
149371 | 14911 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | 10 | 3 | 8 | 58 | 1 | |||
164263 | 6649 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 5 | 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 | |||
173492 | 16554 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
183470 | 4916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
54428 | 50386 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 5 | 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 | |||
70907 | 102876 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
24686 | 20125 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
106329 | 142100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 904 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002972.7027 | 2110318.8393 | 37.7747012881718 | -122.433183544102 | (37.7747012881718, -122.433183544102) | 15 | 5 | 11 | 29492 | 10 | |||
116533 | 138243 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999648.5931 | 2114056.0979 | 37.7847737117432 | -122.444950986247 | (37.7847737117432, -122.444950986247) | 15 | 6 | 1 | 29490 | 31 | |||
51567 | 20965 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2002X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
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 | |||
32402 | 115846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003504.2747 | 2120736.26354 | 37.8033350304463 | -122.432088807873 | (37.8033350304463, -122.432088807873) | 13 | 9 | 1 | 57 | 17 | |||
96630 | 222908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004803.10417 | 2109829.19919 | 37.773460518813 | -122.426816934368 | (37.773460518813, -122.426816934368) | 7 | 9 | 11 | 28852 | 10 | |||
115220 | 115850 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003589.56269 | 2120774.48991 | 37.8034448250715 | -122.431796396884 | (37.8034448250715, -122.431796396884) | 13 | 9 | 1 | 57 | 17 |
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) );