trees
8,298 rows where qLegalStatus_id = 4 sorted by qSpecies_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194479 | 265136 | Undocumented 4 | :: Tree 573 | 100 Winston Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | ||||
140466 | 122695 | Undocumented 4 | Acer saccharum :: Sugar Maple 554 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | ||||
126696 | 99791 | Undocumented 4 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 | 4120-4124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
170610 | 99793 | Undocumented 4 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 | 4120-4124 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
116720 | 113783 | Undocumented 4 | Chorisia speciosa :: Silk Floss Tree 545 | 1188 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6008033 | 2101004 | 37.7494106463882 | -122.41501945132 | (37.7494106463882, -122.41501945132) | 2 | 4 | 7 | 28859 | 19 | |||
118030 | 112152 | Undocumented 4 | Chorisia speciosa :: Silk Floss Tree 545 | 299x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6007772 | 2106483 | 37.7644400562771 | -122.416310015149 | (37.7644400562771, -122.416310015149) | 8 | 4 | 7 | 28859 | 19 | ||||
182353 | 107632 | Undocumented 4 | Chorisia speciosa :: Silk Floss Tree 545 | 814 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010397.84183 | 2104391.4418 | 37.758844416174 | -122.407080469655 | (37.758844416174, -122.407080469655) | 10 | 4 | 7 | 28859 | 19 | |||
168219 | 117624 | Undocumented 4 | Pinus coulteri :: Coulter pine 537 | 890x VERMONT ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
167522 | 104778 | Undocumented 4 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 534 | 736 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6002380.5 | 2103803.5 | 37.7567781475012 | -122.434766079383 | (37.7567781475012, -122.434766079383) | 2 | 4 | 5 | 28862 | 3 | |||
97942 | 122731 | Undocumented 4 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 533 | 310 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003508 | 2106439 | 37.7640785470532 | -122.431054869188 | (37.7640785470532, -122.431054869188) | 15 | 4 | 5 | 28862 | 3 | |||
94771 | 110864 | Undocumented 4 | Aesculus spp :: Horsechestnut 528 | 1798x 22ND ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6012787 | 2103832 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | 10 | 3 | 8 | 28856 | 29 | |||||
137888 | 256220 | Undocumented 4 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 527 | 159X Brewster St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
167534 | 108073 | Undocumented 4 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 519 | 101 BUENA VISTA AVE EAST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001336 | 2108482 | 37.7695648051764 | -122.438713569331 | (37.7695648051764, -122.438713569331) | 15 | 5 | 5 | 29492 | 9 | ||||
189249 | 99561 | Undocumented 4 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 418 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002462 | 2100938 | 37.748914793117 | -122.434279368207 | (37.748914793117, -122.434279368207) | 2 | 4 | 5 | 28862 | 22 | |||||
81274 | 102903 | Undocumented 4 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 514 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6002396 | 2104853 | 37.7596607018428 | -122.434787523187 | (37.7596607018428, -122.434787523187) | 2 | 4 | 5 | 28862 | 3 | |||
145348 | 256222 | Undocumented 4 | Eucalyptus citriodora :: Lemon scented eucalyptus 512 | 159X Brewster St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
73945 | 109029 | Undocumented 4 | Melaleuca leucadendron :: Weeping Tea Tree 511 | 923 CAPP ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007430.9 | 2101912 | 37.7518699557381 | -122.417165865844 | (37.7518699557381, -122.417165865844) | 2 | 4 | 7 | 28859 | 19 | |||||
71813 | 108240 | Undocumented 4 | Prunus serrula :: Birchbark Cherry 510 | 163 DELMAR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999383.5 | 2107248.1 | 37.7660655566694 | -122.445378437485 | (37.7660655566694, -122.445378437485) | 15 | 5 | 5 | 29492 | 9 | |||
67145 | 111046 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
67427 | 111045 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
125533 | 111048 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
175542 | 111047 | Undocumented 4 | Acer pseudoplatanus :: Sycamore Maple 500 | 400x BUCHANAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004666 | 2109838 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | 7 | 9 | 11 | 28852 | 10 | ||||
58781 | 116012 | Undocumented 4 | Salix discolor :: Pussy Willow 485 | 250 HAZELWOOD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 10x10 | Permit Number 777957 | 5996359 | 2095057 | 37.7324187155695 | -122.454958550665 | (37.7324187155695, -122.454958550665) | 9 | 7 | 4 | 59 | 40 | ||
50657 | 103946 | Undocumented 4 | Ilex opaca :: American Holly 473 | 243 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x3 | Permit Number 770210 | 6008640 | 2097502 | 37.7398290200433 | -122.412672885484 | (37.7398290200433, -122.412672885484) | 10 | 7 | 7 | 28859 | 2 | ||
49384 | 122382 | Undocumented 4 | Leptospermum quinquenervia :: Tea Tree 470 | 351 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997768 | 2093550 | 37.7283615794151 | -122.449978755915 | (37.7283615794151, -122.449978755915) | 9 | 7 | 4 | 28861 | 40 | ||||
141901 | 108140 | Undocumented 4 | Prunus spp 'Purpurea' :: Cherry Plum 469 | 3390x 18TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006957.7 | 2105612.4 | 37.7620037686995 | -122.419064704614 | (37.7620037686995, -122.419064704614) | 8 | 4 | 7 | 28859 | 19 | ||||
47691 | 103674 | Undocumented 4 | Castanea dentata :: American Chestnut 466 | 3141 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008036 | 2102674 | 37.7539962579222 | -122.415127271806 | (37.7539962579222, -122.415127271806) | 2 | 4 | 7 | 28859 | 19 | ||||
98461 | 117104 | Undocumented 4 | Rhus lancea :: African Sumac 458 | 50 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012112 | 2107534 | 37.7675689576739 | -122.401372925553 | (37.7675689576739, -122.401372925553) | 14 | 3 | 8 | 28856 | 20 | ||||
140004 | 117106 | Undocumented 4 | Rhus lancea :: African Sumac 458 | 50 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012112 | 2107534 | 37.7675689576739 | -122.401372925553 | (37.7675689576739, -122.401372925553) | 14 | 3 | 8 | 28856 | 20 | ||||
143120 | 117105 | Undocumented 4 | Rhus lancea :: African Sumac 458 | 50 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012112 | 2107534 | 37.7675689576739 | -122.401372925553 | (37.7675689576739, -122.401372925553) | 14 | 3 | 8 | 28856 | 20 | ||||
160394 | 117107 | Undocumented 4 | Rhus lancea :: African Sumac 458 | 50 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012112 | 2107534 | 37.7675689576739 | -122.401372925553 | (37.7675689576739, -122.401372925553) | 14 | 3 | 8 | 28856 | 20 | ||||
184660 | 117103 | Undocumented 4 | Rhus lancea :: African Sumac 458 | 50 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012112 | 2107534 | 37.7675689576739 | -122.401372925553 | (37.7675689576739, -122.401372925553) | 14 | 3 | 8 | 28856 | 20 | ||||
41809 | 106281 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 2 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
85470 | 106280 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 1 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
162309 | 106282 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 3 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
41577 | 108877 | Undocumented 4 | Eucalyptus microtheca :: Flooded Box: Coolibah 455 | 240X NORIEGA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.466107040855 | (37.7547470014972, -122.466107040855) | 1 | 8 | 4 | 56 | 12 | ||||
57401 | 108875 | Undocumented 4 | Eucalyptus microtheca :: Flooded Box: Coolibah 455 | 240X NORIEGA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.466107040855 | (37.7547470014972, -122.466107040855) | 1 | 8 | 4 | 56 | 12 | ||||
133553 | 105750 | Undocumented 4 | Eucalyptus microtheca :: Flooded Box: Coolibah 455 | 240X NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.466107040855 | (37.7547470014972, -122.466107040855) | 1 | 8 | 4 | 56 | 12 | |||
169218 | 108876 | Undocumented 4 | Eucalyptus microtheca :: Flooded Box: Coolibah 455 | 240X NORIEGA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.466107040855 | (37.7547470014972, -122.466107040855) | 1 | 8 | 4 | 56 | 12 | ||||
171986 | 106171 | Undocumented 4 | Tilia spp :: Linden 450 | 2521 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774749 | 6010356.3 | 2105009.4 | 37.7605388656214 | -122.407267703446 | (37.7605388656214, -122.407267703446) | 10 | 4 | 8 | 28859 | 19 | |
77155 | 114188 | Undocumented 4 | New Zealand Tea Tree :: New Zealand Tea Tree 448 | 2200 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5997096 | 2109871 | 37.7731365175856 | -122.453479795748 | (37.7731365175856, -122.453479795748) | 15 | 5 | 2 | 29492 | 16 | ||||
191026 | 115633 | Undocumented 4 | New Zealand Tea Tree :: New Zealand Tea Tree 448 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 6000786.8 | 2104618.2 | 37.7589245060719 | -122.44033609165 | (37.7589245060719, -122.44033609165) | 2 | 4 | 5 | 28862 | 38 | ||||
83779 | 98313 | Undocumented 4 | Acacia dealbata :: Silver Wattle 445 | 160 Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | 9 | 7 | 4 | 59 | 40 | |||||
38387 | 113577 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
81194 | 113578 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
92350 | 113575 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 315X PLYMOUTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
162229 | 113576 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
97487 | 106338 | Undocumented 4 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 497 VALLEY ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779 | 2099138 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | 2 | 7 | 5 | 63 | 22 | ||
107126 | 117095 | Undocumented 4 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 2X 09TH AVE | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 3x3 | 5993083 | 2114893 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | 11 | 6 | 1 | 54 | 11 | |||
108628 | 122389 | Undocumented 4 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 166 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991334 | 2104180 | 37.7571785771329 | -122.472996021046 | (37.7571785771329, -122.472996021046) | 1 | 8 | 4 | 56 | 12 | ||||
113573 | 117093 | Undocumented 4 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 2X 09TH AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 3x3 | 5993083 | 2114893 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | 11 | 6 | 1 | 54 | 11 | |||
192010 | 106337 | Undocumented 4 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 497 VALLEY ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779 | 2099138 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | 2 | 7 | 5 | 63 | 22 | ||
38206 | 106185 | Undocumented 4 | Gleditsia triacanthos 'Aurea' :: Honey Locust 'Aurea' 442 | 1349 ULLOA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | 5991806.5 | 2098368.4 | 37.7412487717429 | -122.470938602248 | (37.7412487717429, -122.470938602248) | 1 | 8 | 4 | 59 | 40 | |||
124874 | 106186 | Undocumented 4 | Gleditsia triacanthos 'Aurea' :: Honey Locust 'Aurea' 442 | 1349 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 5991806.5 | 2098368.4 | 37.7412487717429 | -122.470938602248 | (37.7412487717429, -122.470938602248) | 1 | 8 | 4 | 59 | 40 | |||
121256 | 254289 | Undocumented 4 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 110 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
33042 | 102796 | Undocumented 4 | Magnolia grandiflora 'Timeless Beauty' :: Timeless Beauty Southern Magnolia 431 | 536 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002890 | 2102715 | 37.7538182988272 | -122.43292628008 | (37.7538182988272, -122.43292628008) | 2 | 4 | 5 | 28862 | 22 | ||||
51821 | 105543 | Undocumented 4 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 422 | 123 SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007367.5 | 2109091.5 | 37.7715796297317 | -122.417893993822 | (37.7715796297317, -122.417893993822) | 8 | 2 | 9 | 28853 | 19 | |||
157845 | 107434 | Undocumented 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 3169 WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999560.6 | 2115983.6 | 37.7900611064648 | -122.44539405336 | (37.7900611064648, -122.44539405336) | 13 | 6 | 1 | 29490 | 27 | |||||
52693 | 117558 | Undocumented 4 | Juglans californica :: Walnut: Black (s.calif) 412 | 1388 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007677 | 2101596 | 37.7510161331167 | -122.41629243605 | (37.7510161331167, -122.41629243605) | 2 | 4 | 7 | 28859 | 19 | ||||
144076 | 103688 | Undocumented 4 | Juglans californica :: Walnut: Black (s.calif) 412 | 901X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008052 | 2102672 | 37.7539916655216 | -122.415071798268 | (37.7539916655216, -122.415071798268) | 2 | 4 | 7 | 28859 | 19 | |||
50864 | 107995 | Undocumented 4 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 | 907 Minnesota St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | 6x11 | Permit Number 774103 | 6015290.10173 | 2104424.85479 | 37.7592087238569 | -122.390162955696 | (37.7592087238569, -122.390162955696) | 10 | 3 | 8 | 28856 | 29 | ||
22107 | 104828 | Undocumented 4 | Juglans regia :: Walnut: English 396 | 22 FOREST SIDE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x3 | 5992639.6 | 2098939.5 | 37.7428650146746 | -122.468099596108 | (37.7428650146746, -122.468099596108) | 1 | 8 | 4 | 29491 | 40 | |||
25599 | 121584 | Undocumented 4 | Juglans regia :: Walnut: English 396 | 1190X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6014447 | 2104828 | 37.7602688747214 | -122.393107038214 | (37.7602688747214, -122.393107038214) | 10 | 3 | 8 | 28856 | 29 | |||
56615 | 101253 | Undocumented 4 | Chiranthodendron pentadactylon :: Monkey Hand Tree 393 | 1290X 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992716.9 | 2106688.9 | 37.7641473244126 | -122.468395985577 | (37.7641473244126, -122.468395985577) | 11 | 8 | 11 | 56 | 12 | ||||
39549 | 101657 | Undocumented 4 | Ilex aquifolium :: European Holly 390 | 320 Santa Ana Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992576.9 | 2094712.8 | 37.7312559376124 | -122.46800901581 | (37.7312559376124, -122.46800901581) | 9 | 8 | 4 | 59 | 40 | |||||
78149 | 256162 | Undocumented 4 | Ilex aquifolium :: European Holly 390 | 300X Peralta Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6009722 | 2099567 | 37.7455597283682 | -122.409077438923 | (37.7455597283682, -122.409077438923) | 2 | 7 | 7 | 28859 | 2 | ||||
148468 | 102366 | Undocumented 4 | Ilex aquifolium :: European Holly 390 | 3500 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769587 | 5988245.5 | 2095259.3 | 37.7325053993107 | -122.483023305965 | (37.7325053993107, -122.483023305965) | 1 | 8 | 4 | 64 | 35 | ||||
70058 | 114319 | Undocumented 4 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1X 09TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008059 | 2111315 | 37.7777237259209 | -122.41565950833 | (37.7777237259209, -122.41565950833) | 8 | 2 | 9 | 28853 | 34 | ||||
104004 | 114318 | Undocumented 4 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1X 09TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008059 | 2111315 | 37.7777237259209 | -122.41565950833 | (37.7777237259209, -122.41565950833) | 8 | 2 | 9 | 28853 | 34 | ||||
185906 | 114316 | Undocumented 4 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 1X 09TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008059 | 2111315 | 37.7777237259209 | -122.41565950833 | (37.7777237259209, -122.41565950833) | 8 | 2 | 9 | 28853 | 34 | ||||
161955 | 94038 | Undocumented 4 | Cornus florida :: Eastern Dogwood 385 | 227 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5995000.1 | 2087926.4 | 37.7127617466649 | -122.459140406861 | (37.7127617466649, -122.459140406861) | 9 | 8 | 6 | 28861 | 24 | |||
19491 | 260088 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 1100 Oakdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15x5 | 6017813 | 2093492 | 37.7293289240284 | -122.380677509991 | (37.7293289240284, -122.380677509991) | 10 | 3 | 8 | 58 | 1 | ||||
134710 | 112622 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 226x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
160521 | 102185 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 1840X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | |||
19357 | 256415 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
24901 | 256416 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
83031 | 256421 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
106500 | 256424 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 12 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
118246 | 256426 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 14 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
134265 | 256425 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 13 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
134842 | 256422 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 10 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
144246 | 256434 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 22 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
148780 | 256423 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 11 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
154520 | 256417 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 5 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
155748 | 256420 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 8 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
171982 | 256428 | Undocumented 4 | Ligustrum ovalifolium :: California privet 382 | 3001 Sunset Blvd | 16 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
17244 | 112890 | Undocumented 4 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 | 1X WEBSTER ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 3x3 | 6004219 | 2108568 | 37.7699645303419 | -122.428747509741 | (37.7699645303419, -122.428747509741) | 7 | 9 | 5 | 28862 | 10 | |||
55537 | 110897 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
73430 | 110898 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
86343 | 110894 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
100433 | 110891 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
118023 | 110885 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
124789 | 110899 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
152062 | 110895 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
175598 | 110893 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
182272 | 110896 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
183616 | 110892 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
14272 | 117517 | Undocumented 4 | Sorbus aucuparia :: European Mountain Ash Tr 358 | 3901X 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002396 | 2103508 | 37.7559676553462 | -122.434691344962 | (37.7559676553462, -122.434691344962) | 2 | 4 | 5 | 28862 | 22 | ||||
93538 | 100462 | Undocumented 4 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 236 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992450 | 2097712 | 37.7394836593705 | -122.468665877071 | (37.7394836593705, -122.468665877071) | 1 | 8 | 4 | 59 | 40 | |||||
184760 | 254498 | Undocumented 4 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 160 Oak Park Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5996144 | 2103482 | 37.7555393480762 | -122.456310814197 | (37.7555393480762, -122.456310814197) | 1 | 5 | 4 | 63 | 12 |
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) );