trees

8,298 rows where qLegalStatus_id = 4

✎ View and edit SQL

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)
10 264794 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
12 264792 Undocumented 4 Olea europaea :: Olive Tree 9 99 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
20 264793 Undocumented 4 Olea europaea :: Olive Tree 9 99 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
47 264965 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 951 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994993 2090257 37.7191606150529 -122.45933361899 (37.7191606150529, -122.45933361899) 9 8 6 28861 24
52 264970 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1026 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014048 2089990 37.7195046364539 -122.393448574201 (37.7195046364539, -122.393448574201) 10 3 8 58 1
53 264969 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
65 264979 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
116 113159 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
121 120916 Undocumented 4 Tree(s) :: 17 1430 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2016 12:00:00 AM 3 3x3 Permit Number 778800 5990886 2105639 37.7611586563939 -122.474651843595 (37.7611586563939, -122.474651843595) 1 8 4 56 12
125 92934 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 339 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10     5992211 2096907 37.737259523291 -122.46943364564 (37.737259523291, -122.46943364564) 1 8 4 59 40
128 110722 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 1898X 10th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
131 109387 Undocumented 4 Myoporum laetum :: Myoporum 62 300X BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000704 2110147 37.7741005029649 -122.441019094263 (37.7741005029649, -122.441019094263) 15 5 11 29492 16
140 97920 Undocumented 4 Tree(s) :: 17 399X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6000685 2110085 37.7739291843989 -122.441080369401 (37.7739291843989, -122.441080369401) 15 5 11 29492 16
144 108797 Undocumented 4 :: 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
148 108238 Undocumented 4 Tree(s) :: 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree Private 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
149 244279 Undocumented 4 :: 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
157 114186 Undocumented 4 Shrub :: Shrub 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
162 105806 Undocumented 4 Tree(s) :: 17 1248X ANZA ST   Sidewalk: Curb side : Cutout Tree Private 2       6x3   5994834 2112130 37.7792092085373 -122.461468091676 (37.7792092085373, -122.461468091676) 11 6 2 54 11
164 116129 Undocumented 4 Tree(s) :: 17 1601X Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014258.08027 2092570.23406 37.7266011147526 -122.392902822978 (37.7266011147526, -122.392902822978) 10 3 8 58 1
188 112351 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
194 112359 Undocumented 4 Tree(s) :: 17 1129 DOUGLASS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001379 2100423 37.7474391957634 -122.437987492815 (37.7474391957634, -122.437987492815) 2 4 5 63 22
196 116631 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 12 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
197 104920 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 750 Gonzalez Dr 1 Median : Yard Tree Private 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
198 102463 Undocumented 4 Tree(s) :: 17 3119 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6007346.2 2103903.1 37.7573322957921 -122.417599878082 (37.7573322957921, -122.417599878082) 2 4 7 28859 19
208 107457 Undocumented 4 Prunus spp :: Cherry 68 2682 16TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           5991487.4 2097177.7 37.7379609526954 -122.471955163509 (37.7379609526954, -122.471955163509) 1 8 4 29491 40
217 105438 Undocumented 4 :: 45 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002483 2102334 37.7527490702591 -122.434306541099 (37.7527490702591, -122.434306541099) 2 4 5 28862 22
228 256437 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 25 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
229 121402 Undocumented 4 :: 45 346X Duncan St 1 Back Yard : Yard Tree Private 2       3x3   6004011 2099874 37.7460810947058 -122.428847079389 (37.7460810947058, -122.428847079389) 2 7 5 63 22
230 114428 Undocumented 4 Pinus radiata :: Monterey Pine 15 34x HIGUERA AVE 2 Median : Yard Tree Private 2     56     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
231 116978 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 4 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
233 100684 Undocumented 4 Tree(s) :: 17 400 California St 3 Sidewalk: Curb side : Pot Tree Private 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
264 103685 Undocumented 4 Prunus amygdalus :: Almond 80 901X SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
277 110381 Undocumented 4 Myoporum laetum :: Myoporum 62 2235 PALOU AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       27x18   6011689 2097713 37.740579036374 -122.402145495204 (37.740579036374, -122.402145495204) 10 3 8 58 1
293 102283 Undocumented 4 Tree(s) :: 17 4428 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6000463 2102288 37.7525079029002 -122.441288746114 (37.7525079029002, -122.441288746114) 2 4 5 28862 22
298 107634 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2431 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011247.3 2102253.3 37.7530210518745 -122.403992166267 (37.7530210518745, -122.403992166267) 10 4 8 28859 19
299 116945 Undocumented 4 :: 45 3676 23RD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
301 108803 Undocumented 4 :: 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
307 99748 Undocumented 4 Tree(s) :: 17 4224 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002441 2100645 37.7481090922721 -122.434331041256 (37.7481090922721, -122.434331041256) 2 4 5 28862 22
315 106681 Undocumented 4 Acer spp :: Maple 88 272 COLLINGWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6002031.2 2104270.9 37.7580416780136 -122.436007529668 (37.7580416780136, -122.436007529668) 2 4 5 28862 3
323 106136 Undocumented 4 Tree(s) :: 17 200X RIDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996801 2094865 37.7319168756422 -122.453416604011 (37.7319168756422, -122.453416604011) 9 7 4 59 40
329 101063 Undocumented 4 Tree(s) :: 17 710 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001857 2102025 37.7518650783703 -122.436449244442 (37.7518650783703, -122.436449244442) 2 4 5 28862 22
335 102831 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 25X Lansing St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014531.5 2114230.8 37.7860915609161 -122.393472847757 (37.7860915609161, -122.393472847757) 6 2 9 28855 6
350 119661 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 699x Missouri St 2 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
359 113255 Undocumented 4 Tree(s) :: 17 178 Edgewood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5996632.6 2106029.8 37.7625629978497 -122.454805165139 (37.7625629978497, -122.454805165139) 15 5 11 29492 12
361 107141 Undocumented 4 Tree(s) :: 17 3498 16TH ST   Sidewalk: Curb side : Cutout Tree Private 2           6003565.7 2106565.7 37.764429704069 -122.430864344516 (37.764429704069, -122.430864344516) 15 4 5 28862 3
369 138522 Undocumented 4 Tristania conferta :: 61 1602 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6001658.1955 2114019.9111 37.7847888393579 -122.437995843174 (37.7847888393579, -122.437995843174) 13 6 11 29490 13
380 116339 Undocumented 4 :: 45 1400X Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
392 108811 Undocumented 4 :: 45 301-399 University St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
400 104991 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 669X NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6003139 2104447 37.7585880783392 -122.432188863302 (37.7585880783392, -122.432188863302) 2 4 5 28862 3
403 108117 Undocumented 4 Myoporum laetum :: Myoporum 62 148 28TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           5987142.8 2114987.8 37.7866102289445 -122.488284841308 (37.7866102289445, -122.488284841308) 11 6 1 55 33
405 113785 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
408 109629 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 30 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
412 121036 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1830 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006566 2117108 37.7935458417616 -122.421235781398 (37.7935458417616, -122.421235781398) 13 9 10 28858 32
416 116621 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 2 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
427 114621 Undocumented 4 :: 45 2400X Post St 6 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
434 102445 Undocumented 4 Tree(s) :: 17 900 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001563.3 2088855.6 37.7156882523244 -122.436522388875 (37.7156882523244, -122.436522388875) 9 7 6 28861 5
443 107383 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 73 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6005896.4 2103362 37.7557648742481 -122.422575414787 (37.7557648742481, -122.422575414787) 2 4 5 28859 19
445 110235 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 2346x CASTRO ST 1 Median : Cutout Tree Private 2       3x3   6002664.5 2098664.4 37.7426835115852 -122.433416673574 (37.7426835115852, -122.433416673574) 2 7 5 63 7
447 114683 Undocumented 4 Ficus Spp. :: 101 235 GEARY ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
451 114938 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 14 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
463 116745 Undocumented 4 Myoporum laetum :: Myoporum 62 2998x SLOAT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981657 2096559 37.7356884360348 -122.505897251941 (37.7356884360348, -122.505897251941) 1 8 3 29491 35
465 105354 Undocumented 4 Tree(s) :: 17 3294 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007856.1 2100992.4 37.7493688530402 -122.415630356523 (37.7493688530402, -122.415630356523) 2 4 7 28859 19
466 116275 Undocumented 4 :: 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
468 121614 Undocumented 4 :: 45 800X Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001168 2102650 37.7535420028484 -122.438876681597 (37.7535420028484, -122.438876681597) 2 4 5 28862 22
475 102627 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2039 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6001422 2115424 37.7886306717674 -122.438913657053 (37.7886306717674, -122.438913657053) 13 6 1 29490 27
476 102238 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 1104 York St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
479 122586 Undocumented 4 Prunus spp :: Cherry 68 2500X Lyon St 6 Median : Cutout Tree Private 2     12 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
501 108350 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
506 264804 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
508 113374 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
515 262251 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
534 183705 Undocumented 4 :: 45 3628 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5983226.2116 2105643.5823 37.7607244242532 -122.501143681764 (37.7607244242532, -122.501143681764) 1 8 3 56 35
543 100400 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 88 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 6x3   6008223 2099495 37.7452779444232 -122.414255673266 (37.7452779444232, -122.414255673266) 2 7 7 28859 2
563 100819 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2430X Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
569 112652 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 3100X 26TH ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008747 2100981 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695) 2 4 7 28859 19
618 238270 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 4102 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002298.332 2104734.40291 37.7593295173753 -122.435116825204 (37.7593295173753, -122.435116825204) 2 4 5 28862 3
621 104871 Undocumented 4 Acer japonicum :: Japanese Maple 124 50-52 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2       5x4 Permit Number 770461 6000747.1 2106070.8 37.7629107285672 -122.440577579902 (37.7629107285672, -122.440577579902) 15 5 5 28862 3
653 262559 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
694 114020 Undocumented 4 Crateagus spp :: Hawthorn 130 1 HANGAH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010635 2117072 37.7936755489769 -122.407154109442 (37.7936755489769, -122.407154109442) 3 1 10 28857 4
709 102222 Undocumented 4 Tree(s) :: 17 30 Aloha Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5992101.6 2104316.3 37.7575972316932 -122.470351313846 (37.7575972316932, -122.470351313846) 1 8 4 56 12
731 262111 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2021 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991247 2101647 37.7502185858925 -122.473112177678 (37.7502185858925, -122.473112177678) 1 8 4 29491 12
767 100549 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
770 111807 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
787 110793 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 900 CALIFORNIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009776 2116634 37.7924247975925 -122.410095399183 (37.7924247975925, -122.410095399183) 5 1 10 28857 21
829 262514 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2230 Jerrold Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
838 264883 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1624 48th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
910 259043 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3639 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981868 2098709 37.7416041617746 -122.505327058934 (37.7416041617746, -122.505327058934) 1 8 3 29491 35
932 111099 Undocumented 4 Pinus radiata :: Monterey Pine 15 480X LAKESHORE DR 20 Median : Cutout Tree DPW 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1070 261149 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 322x Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991839 2099782 37.7451320352893 -122.470929181064 (37.7451320352893, -122.470929181064) 1 8 4 29491 40
1093 262511 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2230 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
1096 106130 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 2402 26TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5988342.2 2098891.1 37.7424830020357 -122.482955078155 (37.7424830020357, -122.482955078155) 1 8 3 29491 35
1105 106501 Undocumented 4 Tree(s) :: 17 1266 09TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x6   5993358 2106830.8 37.764573953722 -122.46618893715 (37.764573953722, -122.46618893715) 11 8 11 56 12
1111 99485 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 700X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
1127 263624 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
1134 262481 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2001 Market St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004735 2108212 37.769016230753 -122.426937316023 (37.769016230753, -122.426937316023) 8 4 5 28862 3
1152 259051 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 25 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000711 2094308 37.7306108324003 -122.439859019702 (37.7306108324003, -122.439859019702) 9 7 4 63 40
1190 107158 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 101x Elsie St 1 Unaccepted Street : Yard Tree Private 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2

Next page

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