trees

484 rows where qSpecies_id = 56 sorted by qLegalStatus_id descending

✎ 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)
2730 138025 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     49 Width 0ft   6004878.9655 2114979.8902 37.7876073348692 -122.426921423586 (37.7876073348692, -122.426921423586) 13 9 11 28858 27
2985 138087 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     30 Width 0ft   6004894.5944 2114873.9606 37.7873173623789 -122.426859803648 (37.7873173623789, -122.426859803648) 13 9 11 28858 27
4739 138026 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     57 Width 0ft   6004881.8597 2114953.842 37.7875359766764 -122.426909554358 (37.7875359766764, -122.426909554358) 13 9 11 28858 27
5001 138027 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     39 Width 0ft   6004885.3328 2114935.3188 37.7874853129815 -122.426896218405 (37.7874853129815, -122.426896218405) 13 9 11 28858 27
6626 138028 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     49 Width 0ft   6004887.6482 2114917.9533 37.7874377625804 -122.426886970359 (37.7874377625804, -122.426886970359) 13 9 11 28858 27
13887 2618 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
18571 138024 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     48 Width 0ft   6004873.7558 2115028.5137 37.7877405482561 -122.42694291248 (37.7877405482561, -122.42694291248) 13 9 11 28858 27
28953 2619 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.426928979241 (37.7877373561683, -122.426928979241) 13 9 11 28858 27
40122 2614 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
47435 2617 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
146721 2615 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
165250 2616 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
119017 105441 Private 9 Eucalyptus globulus :: Blue Gum 56 425 WAWONA ST   unknown : Yard Tree Private 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
141599 251417 Private 9 Eucalyptus globulus :: Blue Gum 56 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990003 2112517 37.7799925618685 -122.478208632121 (37.7799925618685, -122.478208632121) 11 6 2 55 26
181524 121089 Private 9 Eucalyptus globulus :: Blue Gum 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
15695 262389 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 67 Rosenkranz St 1 Side Yard : Yard Tree DPW 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
18104 260417 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 335 Corbett Ave 1 Median : Cutout Tree DPW 1       3x3   5999565 2105069 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425) 15 5 5 28862 3
104699 114731 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 934 BRANNAN ST   Back Yard : Yard Tree Private 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
106673 256140 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 892 Moultrie St 1 Side Yard : Yard Tree Private 2       3x3   6007512 2095150 37.7333075704823 -122.416406492547 (37.7333075704823, -122.416406492547) 2 7 7 28859 2
129920 106227 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 38 Stanford Heights Ave 1 Back Yard : Yard Tree Private 2           5997884 2095808.5 37.7345695210024 -122.44974042874 (37.7345695210024, -122.44974042874) 9 7 4 59 40
150726 106275 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 42 Stanford Heights Ave 1 Back Yard : Yard Tree Private 2           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555) 9 7 4 59 40
189109 120533 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 951 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   6010745 2108673 37.7706200263658 -122.406181480785 (37.7706200263658, -122.406181480785) 14 2 9 28853 34
1081 52091 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 300 Dorantes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2005 12:00:00 AM     Permit Number 48287 5993176.51233561 2099718.04340733 37.7450336906204 -122.466299687476 (37.7450336906204, -122.466299687476) 1 8 4 29491 40
37033 92037 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
43440 92035 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
59936 92040 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
81197 92036 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
107250 92038 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
123942 114396 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 3 Sidewalk: Curb side : Cutout Tree Private 2           5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
147660 92033 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
149188 92034 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
157123 66251 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/1990 12:00:00 AM     Permit Number 29352 5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
164270 92039 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
891 207770 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
23740 255978 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 1 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
23924 92900 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 4 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
30833 258289 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 6 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
82626 258290 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 7 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
93652 115295 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X 08TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010511 2109243 37.7721720235673 -122.407031076357 (37.7721720235673, -122.407031076357) 14 2 9 28853 34
98944 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 301X Sargent St 1 Front Yard : Cutout Tree Private 2       3x3   5993018 2089140 37.7159798527116 -122.466079257059 (37.7159798527116, -122.466079257059) 9 8 6 64 24
104435 106173 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 267 Green St 1 Front Yard : Yard Tree Private 2         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098) 3 1 10 308 23
104555 258287 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 4 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
119656 114409 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X ARBALLO DR 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
128772 258286 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 3 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
131738 92899 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 3 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
134246 258292 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 9 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
145770 258288 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 5 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
147696 258285 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 2 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
151892 92897 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 1 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
159425 258291 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 8 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
175631 92898 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 2 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
8037 257932 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
9638 254322 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
19448 254323 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 4 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
20018 256139 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 888 Moultrie St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6007515 2095179 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
22036 254321 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
22782 116019 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2023 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5993447 2101700 37.7504912419676 -122.465508351594 (37.7504912419676, -122.465508351594) 1 8 4 29491 40
35559 122678 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 701x Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6008711 2098131 37.741560100881 -122.412471846631 (37.741560100881, -122.412471846631) 10 7 7 28859 2
36331 256763 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
43919 113860 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
58186 105492 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1575 07TH AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571) 1 8 4 56 12
58510 254319 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
61319 119631 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 265 Fowler Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 3x5   5997384 2099137 37.7436801569324 -122.451709113802 (37.7436801569324, -122.451709113802) 9 7 4 59 40
62684 106004 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 695X CAMPBELL AVE   unknown : Yard Tree Rec/Park 5           6009136.9 2088912.4 37.716271678506 -122.410348471622 (37.716271678506, -122.410348471622) 9 7 8 309 39
72158 113805 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 990X OSHAUGHNESSY BLVD 2 Front Yard : Yard Tree Rec/Park 5       3x30   6000025 2096199 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687) 9 7 4 63 40
74910 114400 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 3 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
79539 95436 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2675 25th Ave 3 Unaccepted Street : Yard Tree Private 2     16     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
81211 116020 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2023 09TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5993447 2101700 37.7504912419676 -122.465508351594 (37.7504912419676, -122.465508351594) 1 8 4 29491 40
82854 114075 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     26     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
85519 113859 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
90362 254305 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
94300 113861 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
96359 122535 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 199x Coso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6007478 2099565 37.7454282725128 -122.416836723884 (37.7454282725128, -122.416836723884) 2 7 7 28859 2
101469 254309 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 6 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
111670 104402 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 301 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2           6000011.7 2094912.1 37.7322297190532 -122.442319949129 (37.7322297190532, -122.442319949129) 9 7 4 63 40
118601 113862 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
122223 113804 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 990X OSHAUGHNESSY BLVD 1 Front Yard : Yard Tree Rec/Park 5       3x30   6000025 2096199 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687) 9 7 4 63 40
124028 257931 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
128096 256447 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 31 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
132508 254295 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 110 Junipero Serra Blvd 7 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
134035 114403 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
134080 114044 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 549X ARLINGTON ST   Median : Cutout Tree Private 2     70     6003400 2095634 37.7344044281823 -122.430657330781 (37.7344044281823, -122.430657330781) 2 7 5 63 7
137649 108201 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 2 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
140170 253136 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3059 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x5   5999298 2114593 37.7862278895056 -122.446202552789 (37.7862278895056, -122.446202552789) 15 6 1 29490 31
140615 96803 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 300X Melrose Ave 1 Unaccepted Street : Yard Tree Private 2     48     5998134.5 2095546.7 37.7338650092742 -122.448855518806 (37.7338650092742, -122.448855518806) 9 7 4 59 40
142283 114069 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     40     5988091 2090188 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801) 1 8 4 64 14
152308 256445 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 29 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
152900 257934 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
154190 121341 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 401X Cargo Way 2 Side Yard : Yard Tree Private 2     18 3x3   6017217 2098844 37.7439915378474 -122.383110313195 (37.7439915378474, -122.383110313195) 10 3 8 58 1
158118 114076 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     24     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
165630 108200 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 1 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
170679 257933 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
171148 256446 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 30 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
173822 254318 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
177622 254294 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 110 Junipero Serra Blvd 6 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
184600 115801 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 9M CAIRE TER 1 Front Yard : Yard Tree Private 2           6012720 2101959 37.7522951385919 -122.398878598484 (37.7522951385919, -122.398878598484) 10 3 8 28856 29

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