55 rows where SiteOrder = 5 and qSpecies_id = 5

View and edit SQL

SiteOrder

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)
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
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
12712 19967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY41 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);