64 rows where PlotSize = "Width 4ft" and qSpecies_id = 6

View and edit SQL

These facets timed out: PlotSize

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)
1269 262440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
1777 260927 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 354 Point Lobos Ave 1 Sidewalk: Property side : Cutout Tree Private 2       Width 4ft   5981645 2112753 37.7801518383055 -122.507139709579 (37.7801518383055, -122.507139709579) 11 6 2 55 26
2939 262442 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
9404 176900 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005606.72127 2092829.97134 37.7268299557374 -122.422828750447 (37.7268299557374, -122.422828750447) 9 7 7 309 5
12204 164659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 150 Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 Width 4ft Permit Number 785596 5994533.58351 2098539.8464 37.7418768645301 -122.461521809887 (37.7418768645301, -122.461521809887) 1 8 4 59 40
15133 129382 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008704.56308 2112447.63135 37.7808699297471 -122.413506401504 (37.7808699297471, -122.413506401504) 7 10 9 28852 36
15310 262443 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
15599 262439 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
16685 251006 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 348 Point Lobos Ave 1 Sidewalk: Property side : Cutout Tree Private 2     2 Width 4ft   5981660.38525 2112713.01394 37.7800429545487 -122.507083518802 (37.7800429545487, -122.507083518802) 11 6 2 55 26
20503 129384 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008749.2926 2112454.62361 37.7808916402666 -122.413352154294 (37.7808916402666, -122.413352154294) 7 10 9 28852 36
21404 129375 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 454 Walnut St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998637.858 2115126.26996 37.7876543864995 -122.448524881439 (37.7876543864995, -122.448524881439) 13 6 1 54 31
21599 129376 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6002240.59165 2116825.10443 37.7925242837291 -122.436181762774 (37.7925242837291, -122.436181762774) 13 9 1 29490 27
25424 176901 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005600.43917 2092849.05844 37.7268820102711 -122.422851823466 (37.7268820102711, -122.422851823466) 9 7 7 309 5
27719 250553 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 1 : Tree Private 2     8 Width 4ft   5988175.48547 2115367.76095 37.7877136895948 -122.484739928202 (37.7877136895948, -122.484739928202) 11 6 1 55 33
30385 181018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.04691 37.7143947132291 -122.43841724089 (37.7143947132291, -122.43841724089) 9 7 6 28861 5
31769 227126 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1689 Noe St 2 Sidewalk: Curb side : Pot Tree Private 2     9 Width 4ft   6003395.21055 2098417.4445 37.742046857971 -122.430872467617 (37.742046857971, -122.430872467617) 2 7 5 63 22
39381 181028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.46766 37.7151323074928 -122.440070279342 (37.7151323074928, -122.440070279342) 9 7 6 28861 5
41709 129378 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6002236.43678 2116865.63553 37.7926353355998 -122.436199040575 (37.7926353355998, -122.436199040575) 13 9 1 29490 27
50352 227104 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 35 Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5998773.50017 2105374.28879 37.7608857006352 -122.447353415547 (37.7608857006352, -122.447353415547) 15 5 11 29492 12
55754 176898 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005619.38027 2092788.13013 37.7267157831975 -122.422782016296 (37.7267157831975, -122.422782016296) 9 7 7 309 5
72338 227121 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 791 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001433.87774 2099966.59062 37.7461891245209 -122.437765046244 (37.7461891245209, -122.437765046244) 2 7 5 63 22
81750 129385 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 722 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009662.68842 2115877.38276 37.7903409582254 -122.41043401253 (37.7903409582254, -122.41043401253) 5 1 10 28857 21
82485 118666 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 465 43rd Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5982506.22463 2112651.75572 37.7799245369815 -122.504152889313 (37.7799245369815, -122.504152889313) 11 6 2 55 26
85415 207038 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 270 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5994641.46146 2100307.89339 37.7467376875983 -122.461276941602 (37.7467376875983, -122.461276941602) 1 8 4 29491 40
85418 227105 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 436 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5998543.73083 2106633.91182 37.7643311769734 -122.448238788212 (37.7643311769734, -122.448238788212) 15 5 11 29492 9
92442 129379 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1765 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005697.11148 2117184.40611 37.793706610722 -122.424247645012 (37.793706610722, -122.424247645012) 13 9 1 28858 27
95828 129377 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2500 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6002239.2844 2116842.37021 37.7925716168296 -122.436187522037 (37.7925716168296, -122.436187522037) 13 9 1 29490 27
102876 119072 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 635 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2016 12:00:00 AM 3 Width 4ft Permit Number 778557 5981931.09212 2111414.85236 37.7764945246953 -122.506050759134 (37.7764945246953, -122.506050759134) 11 6 2 55 26
102966 206997 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1290 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5992719.48539 2106665.14578 37.7640822509305 -122.46838531524 (37.7640822509305, -122.46838531524) 11 8 11 56 12
106437 250555 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 3 : Tree Private 2     5 Width 4ft   5988156.37986 2115366.75845 37.7877098242971 -122.484805955556 (37.7877098242971, -122.484805955556) 11 6 1 55 33
107699 129383 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008721.10925 2112450.33412 37.7808782799549 -122.413449351208 (37.7808782799549, -122.413449351208) 7 10 9 28852 36
108454 227082 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4021 Mission St 1 : Tree Private 2     4 Width 4ft   6004538.86235 2095169.33967 37.7331930297319 -122.426686831253 (37.7331930297319, -122.426686831253) 2 7 7 28861 2
109143 181019 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.7144296473919 -122.438501549606 (37.7144296473919, -122.438501549606) 9 7 6 28861 5
112736 227106 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 436 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5998542.97606 2106650.29925 37.7643761295797 -122.448242578852 (37.7643761295797, -122.448242578852) 15 5 11 29492 9
117385 181020 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 183 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.93011 37.7144764921819 -122.438602919392 (37.7144764921819, -122.438602919392) 9 7 6 28861 5
119325 129374 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 454 Walnut St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5998634.47077 2115144.95556 37.7877054985629 -122.448537946784 (37.7877054985629, -122.448537946784) 13 6 1 54 31
125716 119982 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 250 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5987459.3505 2114288.69945 37.7847091625278 -122.487138302864 (37.7847091625278, -122.487138302864) 11 6 1 55 26
133452 181027 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.24811 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188) 9 7 6 28861 5
134071 227103 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 138 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5998021.55452 2105968.74453 37.7624749295086 -122.449996897152 (37.7624749295086, -122.449996897152) 15 5 11 29492 9
137770 206987 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1248 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992091.43933 2106913.61789 37.7647281934706 -122.470575621288 (37.7647281934706, -122.470575621288) 11 8 11 56 12
138303 191219 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 318 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010580.39617 2106780.39752 37.7654141639451 -122.406617457953 (37.7654141639451, -122.406617457953) 8 4 8 28853 19
142268 129380 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 730 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008321.92773 2115014.63424 37.7878968077251 -122.415011874722 (37.7878968077251, -122.415011874722) 5 1 10 28858 21
145000 227089 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Alemany Blvd 17 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6009456.29094 2095946.49023 37.7356037074354 -122.409740715285 (37.7356037074354, -122.409740715285) 10 7 7 28859 2
147718 201819 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 3 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.77069 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393) 10 3 8 58 1
148373 129381 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 555 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008630.87446 2114175.52263 37.7856101663154 -122.413883591577 (37.7856101663154, -122.413883591577) 7 10 9 28852 36
149415 201820 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 4 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.7289227860515 -122.369449472416 (37.7289227860515, -122.369449472416) 10 3 8 58 1
150091 129390 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 902 Vallejo St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009192.86484 2118752.75452 37.798209676283 -122.412262888224 (37.798209676283, -122.412262888224) 3 1 10 308 21
153170 191220 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2300 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6010900.2167 2105543.22676 37.762035060293 -122.405424130428 (37.762035060293, -122.405424130428) 8 3 8 28856 29
153442 227122 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1137 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6001978.98288 2100703.16052 37.7482425519531 -122.435932838524 (37.7482425519531, -122.435932838524) 2 4 5 28862 22
153956 176899 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005613.54422 2092807.28897 37.7267680598911 -122.422803552358 (37.7267680598911, -122.422803552358) 9 7 7 309 5
154133 227547 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001390.11593 2102052.79607 37.7519148588942 -122.438065782205 (37.7519148588942, -122.438065782205) 2 4 5 28862 22
156551 206986 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1284 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5992719.06604 2106665.13626 37.7640822005694 -122.468386764944 (37.7640822005694, -122.468386764944) 11 8 11 56 12
159328 201821 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 5 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.44708 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782) 10 3 8 58 1
168066 181011 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 207 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.31583 2088326.00254 37.7142089699327 -122.438012171843 (37.7142089699327, -122.438012171843) 9 7 6 28861 5
176426 227107 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 39 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5998391.27095 2106242.70654 37.7632483086886 -122.448737922716 (37.7632483086886, -122.448737922716) 15 5 11 29492 9
176832 207039 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 270 Magellan Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994635.03268 2100302.9111 37.7467236374953 -122.461298810415 (37.7467236374953, -122.461298810415) 1 8 4 29491 40
181974 227119 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022) 2 7 5 63 22
183672 250554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 El Camino Del Mar 2 : Tree Private 2     5 Width 4ft   5988163.80572 2115366.95271 37.7877107901693 -122.484780278081 (37.7877107901693, -122.484780278081) 11 6 1 55 33
184554 201822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 6 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.02992 37.7288418326792 -122.369520189723 (37.7288418326792, -122.369520189723) 10 3 8 58 1
188729 227153 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 105 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008266.03922 2099383.96222 37.7449754768472 -122.414098996293 (37.7449754768472, -122.414098996293) 2 7 7 28859 2
189147 191218 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 477 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6011234.32907 2106146.16371 37.7637092651804 -122.404310998169 (37.7637092651804, -122.404310998169) 8 3 8 28856 29
192824 227120 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6001486.23397 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743) 2 7 5 63 22
192989 181010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 215 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.90059 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327) 9 7 6 28861 5
194177 181017 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.438369065102 (37.7143700996689, -122.438369065102) 9 7 6 28861 5

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