trees

8,298 rows where qLegalStatus_id = 4 sorted by SiteOrder

✎ 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)
184029 100075 Undocumented 4 Tree(s) :: 17 707-709 Noe St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003067 2104139 37.7577383015231 -122.432415873427 (37.7577383015231, -122.432415873427) 2 4 5 28862 3
184296 104943 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 830X Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
184704 104820 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 701 CASTRO ST   Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002463.2 2104094.7 37.7575824076205 -122.434500892974 (37.7575824076205, -122.434500892974) 2 4 5 28862 3
186051 107857 Undocumented 4 Tree(s) :: 17 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774528 5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
186940 97797 Undocumented 4 Tree(s) :: 17 400 Sussex St   Front Yard : Yard Tree Private 2   11/14/2011 12:00:00 AM 17   Permit Number 768175 6000884.7 2096726.7 37.7372619068373 -122.439431826375 (37.7372619068373, -122.439431826375) 2 7 5 63 7
190527 106859 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 946 RHODE ISLAND ST   Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 14 3x3 Permit Number 773008 6011839.2 2104029.4 37.7579308843014 -122.402070102772 (37.7579308843014, -122.402070102772) 10 3 8 28856 29
191057 100769 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3701 21st St   Front Yard : Yard Tree Private 2     55   Street tree w/in RoW 6003717 2103606 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292) 2 4 5 28862 22
191821 104940 Undocumented 4 Pinus radiata :: Monterey Pine 15 111X Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990327.80869 2090136.76282 37.718561145924 -122.475450461306 (37.718561145924, -122.475450461306) 1 8 4 64 14
193894 107703 Undocumented 4 Tree(s) :: 17 41 Hill St   Sidewalk: Curb side : Cutout Tree Private 2   10/15/2014 12:00:00 AM 3 3x3 Permit Number 773950 6006079.45841 2103417.96835 37.7559288760699 -122.421946314733 (37.7559288760699, -122.421946314733) 2 4 5 28859 19
194229 98736 Undocumented 4 Tree(s) :: 17 89 Paradise Ave   Sidewalk: Property side : Yard Tree Private 2           6000827.4 2096045.9 37.7353893278652 -122.439581147409 (37.7353893278652, -122.439581147409) 2 7 5 63 7
194337 265035 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194339 265037 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194353 265038 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194365 265036 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1219 122783 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 424 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6006739 2101281 37.7500984250046 -122.419513794578 (37.7500984250046, -122.419513794578) 2 4 7 28859 19
1588 260075 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 171X Gellert Dr 1 Median : Yard Tree Private 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
1769 251583 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM   3x3   5995352 2086409 37.7086155444167 -122.457814401925 (37.7086155444167, -122.457814401925) 9 7 6 28861 25
1918 262485 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 500X Delta St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6009406 2087980 37.7137265813857 -122.409352565386 (37.7137265813857, -122.409352565386) 9 7 8 309 39
1922 260512 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 180 Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990850 2091280 37.7217304489912 -122.473728831815 (37.7217304489912, -122.473728831815) 9 8 4 64 40
1943 262553 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2230 256764 Undocumented 4 Tree(s) :: 17 25 Serrano Dr 1 Sidewalk: Property side : Cutout Tree Private 2   09/25/2019 12:00:00 AM 3 6x6 Permit Number 782398 5990027 2090605 37.7198293671123 -122.476524410241 (37.7198293671123, -122.476524410241) 1 8 4 64 14
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2450 251744 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 70 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002620 2086992 37.710631205907 -122.432736905509 (37.710631205907, -122.432736905509) 9 7 6 28861 5
2670 262494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2861 116035 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 280 GLENVIEW DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5999243 2100752 37.748220848146 -122.445397263788 (37.748220848146, -122.445397263788) 2 5 5 63 38
2879 261758 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 49 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007215 2095432 37.7340651744382 -122.417453284567 (37.7340651744382, -122.417453284567) 2 7 7 28859 2
2944 97145 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2001X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6008686.3 2106815.2 37.7654035712889 -122.413171184614 (37.7654035712889, -122.413171184614) 8 4 7 28859 19
2945 98684 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2           6014207 2094775 37.7326521179743 -122.393233618799 (37.7326521179743, -122.393233618799) 10 3 8 58 1
3033 121390 Undocumented 4 Shrub :: Shrub 66 1301x 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
3300 113370 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
3301 102850 Undocumented 4 Tree(s) :: 17 25X Guy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4   6014185 2114270 37.7861799368485 -122.394674400267 (37.7861799368485, -122.394674400267) 6 2 9 28855 6
3312 102758 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1392 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5993422.3 2106025.2 37.7623656970292 -122.465908002531 (37.7623656970292, -122.465908002531) 1 8 11 56 12
3419 259044 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3649 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981832 2098708 37.7415992976029 -122.505451458513 (37.7415992976029, -122.505451458513) 1 8 3 29491 35
3496 98500 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1670 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990941.3 2104038.3 37.7567667631156 -122.474343775715 (37.7567667631156, -122.474343775715) 1 8 4 56 12
3509 99817 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
3566 246019 Undocumented 4 Olea europaea :: Olive Tree 9 609 Clayton St 1 Sidewalk: Curb side : Pot Tree Private 2     16 Width 0ft   5998477.1179 2108551.0541 37.7695913556898 -122.448607268219 (37.7695913556898, -122.448607268219) 15 5 11 29492 9
3596 264801 Undocumented 4 Olea europaea :: Olive Tree 9 350 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011023 2089107 37.7169115603385 -122.403842847789 (37.7169115603385, -122.403842847789) 10 7 8 309 39
3697 114907 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 248 LOBOS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5994525 2088748 37.7149903414399 -122.460842000428 (37.7149903414399, -122.460842000428) 9 8 6 28861 24
3723 260511 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 199X Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990954 2091213 37.7215525064104 -122.47336445039 (37.7215525064104, -122.47336445039) 9 8 4 64 40
3775 262460 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 88 06th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009992 2112469 37.7810008079546 -122.409054015659 (37.7810008079546, -122.409054015659) 14 2 9 28853 34
3825 263630 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1020 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000550 2112598 37.7808215534457 -122.441727743189 (37.7808215534457, -122.441727743189) 15 5 1 29490 16
3950 230064 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 501 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007631.21664 2095734.29453 37.7349186191825 -122.416035690789 (37.7349186191825, -122.416035690789) 2 7 7 28859 2
4072 100150 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 4007 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6002942 2105314 37.7609574805046 -122.432932117926 (37.7609574805046, -122.432932117926) 2 4 5 28862 3
4084 259522 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 309 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994311 2099921 37.7456563517477 -122.462391578862 (37.7456563517477, -122.462391578862) 1 8 4 29491 40
4127 74230 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1011 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1996 12:00:00 AM 10     6011143.4423 2118449.9882 37.7974876128867 -122.405491940883 (37.7974876128867, -122.405491940883) 3 1 10 308 23
4280 264767 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 90x Guy Pl 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
4317 261373 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1701x 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2020 12:00:00 AM 3 3x3   5983095 2103514 37.7548694854578 -122.501439939014 (37.7548694854578, -122.501439939014) 1 8 3 56 35
4323 264887 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 99x South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
4337 106918 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 274 PUTNAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009044.8 2096077.1 37.7359392652864 -122.411172625582 (37.7359392652864, -122.411172625582) 10 7 7 28859 2
4356 262525 Undocumented 4 Tree(s) :: 17 410 Alpha St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     4x6   6010538 2087515 37.7125131447181 -122.405407212047 (37.7125131447181, -122.405407212047) 9 7 8 309 39
4569 104897 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 303 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4589 261026 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 758 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5989802 2110189 37.7735888483109 -122.478733667362 (37.7735888483109, -122.478733667362) 11 6 2 55 26
4670 107425 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 1600X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345) 15 5 11 29492 9
4710 143042 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 443 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6010246.7521 2120590.0026 37.8033133880365 -122.408745792286 (37.8033133880365, -122.408745792286) 3 1 10 308 23
4752 107181 Undocumented 4 Geijera parviflora :: Australian Willow 25 1520 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 6x9   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
4766 121797 Undocumented 4 Myoporum laetum :: Myoporum 62 310 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 779075 6004274 2096577 37.7370431692485 -122.427702791955 (37.7370431692485, -122.427702791955) 2 7 5 63 7
4869 102616 Undocumented 4 Ulmus spp :: Elm Spp 98 2000X Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009928.4 2120915.8 37.8041901109125 -122.409870477339 (37.8041901109125, -122.409870477339) 3 1 10 308 23
4872 262191 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1799x 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992411 2103494 37.7553572944486 -122.469221443954 (37.7553572944486, -122.469221443954) 1 8 4 56 12

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