trees
3,965 rows where qSpecies_id = 70 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129614 | 247936 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1149 Esmeralda Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010249.43041 | 2098747.94631 | 37.7433403177918 | -122.407195931541 | (37.7433403177918, -122.407195931541) | 10 | 7 | 7 | 28859 | 2 | ||||
129903 | 220136 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2501 25th St | 4 | Front Yard : Yard | Tree | Private 2 | 15 | 6011420.78009 | 2101810.83863 | 37.7518158408332 | -122.403361110834 | (37.7518158408332, -122.403361110834) | 10 | 4 | 8 | 28859 | 19 | ||||
130230 | 175010 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Hester Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6012675.7431 | 2088120.44685 | 37.7142948767719 | -122.39806090961 | (37.7142948767719, -122.39806090961) | 10 | 3 | 8 | 309 | 1 | ||||
135356 | 220189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 77 | Front Yard : Yard | Tree | Private 2 | 10 | 6004903.37501 | 2096531.93768 | 37.7369550197456 | -122.425523551887 | (37.7369550197456, -122.425523551887) | 2 | 7 | 5 | 28859 | 2 | ||||
139007 | 249914 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 28 | Width 0ft | 6011214.96486 | 2120409.42645 | 37.8028717518996 | -122.405382516107 | (37.8028717518996, -122.405382516107) | 3 | 1 | 10 | 308 | 23 | |||
140013 | 220160 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 22 | Front Yard : Yard | Tree | Private 2 | 18 | 6004872.2864 | 2096465.4493 | 37.7367707009968 | -122.425626308409 | (37.7367707009968, -122.425626308409) | 2 | 7 | 5 | 28859 | 2 | ||||
141874 | 249811 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6010658.60603 | 2121034.26523 | 37.8045562828122 | -122.40735188838 | (37.8045562828122, -122.40735188838) | 3 | 1 | 10 | 308 | 23 | |||
142914 | 220195 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 67 | Front Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6003539.74229 | 2095678.61576 | 37.7345348487982 | -122.430177378003 | (37.7345348487982, -122.430177378003) | 2 | 7 | 5 | 63 | 7 | |||
143807 | 220190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 8 | 6004897.78998 | 2096535.50608 | 37.7369645021978 | -122.425543115723 | (37.7369645021978, -122.425543115723) | 2 | 7 | 5 | 28859 | 2 | ||||
143953 | 220187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 75 | Front Yard : Yard | Tree | Private 2 | 8 | 6004907.90324 | 2096539.115 | 37.7369749829053 | -122.42550840641 | (37.7369749829053, -122.42550840641) | 2 | 7 | 5 | 28859 | 2 | ||||
144421 | 220199 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 7 | Width 5ft | 6003519.67627 | 2095667.91857 | 37.7345043401998 | -122.430245989975 | (37.7345043401998, -122.430245989975) | 2 | 7 | 5 | 63 | 7 | |||
149033 | 220151 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 8 | 6005128.65815 | 2096758.77235 | 37.7375905832326 | -122.424760779309 | (37.7375905832326, -122.424760779309) | 2 | 7 | 5 | 28859 | 2 | ||||
149369 | 175013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6013185.59041 | 2087064.24232 | 37.7114231310315 | -122.396224684625 | (37.7114231310315, -122.396224684625) | 10 | 3 | 8 | 309 | 1 | |||
150282 | 125279 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 6006714.73127 | 2119776.90963 | 37.8008823804688 | -122.42091073396 | (37.8008823804688, -122.42091073396) | 5 | 1 | 1 | 28858 | 32 | ||||
152684 | 217836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 26 | Front Yard : Yard | Tree | Private 2 | 15 | 5991394.92255 | 2095812.43356 | 37.7342069253901 | -122.472175410894 | (37.7342069253901, -122.472175410894) | 1 | 8 | 4 | 64 | 40 | ||||
153757 | 220181 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 46 | Front Yard : Yard | Tree | Private 2 | 9 | 6004987.92222 | 2096576.46546 | 37.7370820597802 | -122.425234401841 | (37.7370820597802, -122.425234401841) | 2 | 7 | 5 | 28859 | 2 | ||||
153812 | 188663 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Amador St | 10 | Front Yard : Yard | Tree | Private 2 | 10 | Width 1ft | 6017654.78408 | 2099538.16845 | 37.7459217650856 | -122.381644807281 | (37.7459217650856, -122.381644807281) | 10 | 3 | 8 | 58 | 1 | |||
154044 | 220186 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 12 | 6004903.97159 | 2096543.19438 | 37.7369859618163 | -122.425522290127 | (37.7369859618163, -122.425522290127) | 2 | 7 | 5 | 28859 | 2 | ||||
155179 | 220183 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 27 | 6004926.20278 | 2096562.8505 | 37.7370411891885 | -122.425446825336 | (37.7370411891885, -122.425446825336) | 2 | 7 | 5 | 28859 | 2 | ||||
155850 | 217844 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 34 | Front Yard : Yard | Tree | Private 2 | 13 | 5991434.00834 | 2095858.95759 | 37.7343369305015 | -122.472043670098 | (37.7343369305015, -122.472043670098) | 1 | 8 | 4 | 64 | 40 | ||||
158552 | 125280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 6 | Front Yard : Yard | Tree | Private 2 | 15 | 6006711.33718 | 2119778.11421 | 37.8008854966263 | -122.420922564536 | (37.8008854966263, -122.420922564536) | 5 | 1 | 1 | 28858 | 32 | ||||
159214 | 220185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 6 | 6004909.03243 | 2096549.63363 | 37.7370039284954 | -122.42550525066 | (37.7370039284954, -122.42550525066) | 2 | 7 | 5 | 28859 | 2 | ||||
159232 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
160865 | 220180 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 45 | Front Yard : Yard | Tree | Private 2 | 8 | 6004956.45114 | 2096571.71335 | 37.7370672335752 | -122.425342873587 | (37.7370672335752, -122.425342873587) | 2 | 7 | 5 | 28859 | 2 | ||||
161712 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | 9 | 7 | 4 | 59 | 40 | ||||
161713 | 220178 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 43 | Front Yard : Yard | Tree | Private 2 | 12 | 6004980.92808 | 2096566.55389 | 37.7370544497104 | -122.425257878673 | (37.7370544497104, -122.425257878673) | 2 | 7 | 5 | 28859 | 2 | ||||
162767 | 249862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011661.36372 | 2120433.37836 | 37.8029624664958 | -122.403839424247 | (37.8029624664958, -122.403839424247) | 3 | 1 | 10 | 308 | 23 | |||
163258 | 220153 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6 | Width 9ft | 6004145.42049 | 2095858.4508 | 37.735062921706 | -122.428096157927 | (37.735062921706, -122.428096157927) | 2 | 7 | 5 | 28861 | 2 | |||
163522 | 175011 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Hester Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6012671.33567 | 2088131.05018 | 37.7143237459272 | -122.398076886938 | (37.7143237459272, -122.398076886938) | 10 | 3 | 8 | 309 | 1 | ||||
163650 | 220197 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 69 | Front Yard : Yard | Tree | Private 2 | 10 | Width 5ft | 6003530.33086 | 2095674.11312 | 37.7345219525108 | -122.43020959532 | (37.7345219525108, -122.43020959532) | 2 | 7 | 5 | 63 | 7 | |||
164231 | 175017 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Nueva Ave | 7 | Front Yard : Yard | Tree | Private 2 | 1 | Width 4ft | 6013060.88681 | 2087564.62077 | 37.7127901320227 | -122.396690751081 | (37.7127901320227, -122.396690751081) | 10 | 3 | 8 | 58 | 1 | |||
164393 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 Fairfax Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||||
164448 | 220163 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 14 | 6004924.61859 | 2096505.26609 | 37.7368829858608 | -122.42544820577 | (37.7368829858608, -122.42544820577) | 2 | 7 | 5 | 28859 | 2 | ||||
165773 | 220154 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 7 | 6004158.18023 | 2095867.64857 | 37.7350888986179 | -122.428052698177 | (37.7350888986179, -122.428052698177) | 2 | 7 | 5 | 28861 | 2 | ||||
168817 | 125281 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 7 | Front Yard : Yard | Tree | Private 2 | 13 | 6006708.63096 | 2119779.53165 | 37.8008892360157 | -122.42093202991 | (37.8008892360157, -122.42093202991) | 5 | 1 | 1 | 28858 | 32 | ||||
168890 | 220169 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 33 | Front Yard : Yard | Tree | Private 2 | 25 | 6004952.51664 | 2096535.60689 | 37.7369678710776 | -122.425353908278 | (37.7369678710776, -122.425353908278) | 2 | 7 | 5 | 28859 | 2 | ||||
169120 | 188708 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Bridgeview Dr | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6014073.74253 | 2095336.92691 | 37.7341876502374 | -122.393733643518 | (37.7341876502374, -122.393733643518) | 10 | 3 | 8 | 58 | 1 | ||||
170831 | 253605 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5997753 | 2098469 | 37.741867117319 | -122.450385062638 | (37.741867117319, -122.450385062638) | 9 | 7 | 4 | 59 | 40 | ||||
170904 | 220191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 11 | 6004894.80738 | 2096532.47755 | 37.7369560180099 | -122.425553212433 | (37.7369560180099, -122.425553212433) | 2 | 7 | 5 | 28859 | 2 | ||||
171800 | 249837 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011222.46721 | 2120367.48226 | 37.8027570028893 | -122.405353598393 | (37.8027570028893, -122.405353598393) | 3 | 1 | 10 | 308 | 23 | |||
172072 | 220148 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6004123.55506 | 2095814.84307 | 37.7349419476051 | -122.428168647787 | (37.7349419476051, -122.428168647787) | 2 | 7 | 5 | 28861 | 2 | ||||
173671 | 111532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 10 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
173737 | 220166 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 30 | Front Yard : Yard | Tree | Private 2 | 19 | 6004931.1825 | 2096526.65396 | 37.7369420829968 | -122.425427033027 | (37.7369420829968, -122.425427033027) | 2 | 7 | 5 | 28859 | 2 | ||||
174242 | 249860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011669.48421 | 2120431.50277 | 37.8029577702374 | -122.403811190928 | (37.8029577702374, -122.403811190928) | 3 | 1 | 10 | 308 | 23 | |||
175371 | 94602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2939 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.94586 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | 13 | 9 | 1 | 57 | 27 | ||
178478 | 97977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008560.78342 | 2094185.68429 | 37.7307186899072 | -122.412712397273 | (37.7307186899072, -122.412712397273) | 9 | 3 | 7 | 309 | 28 | ||
178574 | 220152 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 San Jose Ave | 7 | Front Yard : Yard | Tree | Private 2 | 7 | 6005125.32169 | 2096750.37402 | 37.7375673348643 | -122.424771717755 | (37.7375673348643, -122.424771717755) | 2 | 7 | 5 | 28859 | 2 | ||||
179305 | 111510 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800x BOSWORTH ST | 5 | Front Yard : Yard | Tree | DPW 1 | 20 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
179817 | 220202 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 75 | Front Yard : Yard | Tree | Private 2 | 7 | 6003538.0871 | 2095667.44086 | 37.7345040713105 | -122.430182303581 | (37.7345040713105, -122.430182303581) | 2 | 7 | 5 | 63 | 7 | ||||
180510 | 220145 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450 Bosworth St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6003154.04833 | 2095235.16031 | 37.7332953680856 | -122.431479202413 | (37.7332953680856, -122.431479202413) | 2 | 7 | 5 | 28861 | 25 | ||||
181284 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
182164 | 125285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1015 Vallejo St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 6008615.56594 | 2118630.81045 | 37.7978424372369 | -122.414251888207 | (37.7978424372369, -122.414251888207) | 5 | 1 | 10 | 308 | 21 | ||||
182307 | 217843 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 33 | Front Yard : Yard | Tree | Private 2 | 24 | 5991434.23471 | 2095869.69851 | 37.7343664354551 | -122.472043670093 | (37.7343664354551, -122.472043670093) | 1 | 8 | 4 | 64 | 40 | ||||
182310 | 249861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011664.77155 | 2120432.02609 | 37.8029589438729 | -122.403827536111 | (37.8029589438729, -122.403827536111) | 3 | 1 | 10 | 308 | 23 | |||
185202 | 188630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Tulare St | 12 | Front Yard : Yard | Tree | Private 2 | 14 | 6016199.1477 | 2100300.81075 | 37.7479353426391 | -122.386731417715 | (37.7479353426391, -122.386731417715) | 3 | 8 | 58 | 1 | |||||
186702 | 220159 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 67 | Front Yard : Yard | Tree | Private 2 | 18 | 6004532.29415 | 2096115.92873 | 37.73579177907 | -122.426776927106 | (37.73579177907, -122.426776927106) | 2 | 7 | 5 | 28861 | 2 | ||||
187412 | 111556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 34 | Front Yard : Yard | Tree | DPW 1 | 6 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
188011 | 125289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900 Green St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6008651.45364 | 2119007.8784 | 37.7988797881271 | -122.414154397206 | (37.7988797881271, -122.414154397206) | 5 | 1 | 10 | 308 | 32 | ||||
190199 | 175014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 8ft | 6013188.07866 | 2087071.75218 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | 10 | 3 | 8 | 309 | 1 | |||
190854 | 97981 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 11 | Front Yard : Yard | Tree | Private 2 | 3x105 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | ||||
191672 | 217842 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 32 | Front Yard : Yard | Tree | Private 2 | 8 | 5991425.94511 | 2095892.37177 | 37.734428210799 | -122.472073981738 | (37.734428210799, -122.472073981738) | 1 | 8 | 4 | 64 | 40 | ||||
193459 | 220165 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 29 | Front Yard : Yard | Tree | Private 2 | 22 | 6004939.36103 | 2096521.46367 | 37.7369282937109 | -122.425398386937 | (37.7369282937109, -122.425398386937) | 2 | 7 | 5 | 28859 | 2 | ||||
5095 | 200603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 52 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.385609317623 | (37.733790555057, -122.385609317623) | 10 | 3 | 8 | 58 | 1 | |||
18623 | 99145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 302X Pacheco St | 29 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
19890 | 3695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | 10 | 3 | 8 | 58 | 1 | |||
27485 | 173729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
28295 | 3742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.7444710828997 | -122.38401932754 | (37.7444710828997, -122.38401932754) | 10 | 3 | 8 | 58 | 1 | |||
28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 10 | 3 | 8 | 58 | 1 | ||
29316 | 200553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 29 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016224.313 | 2095613.1578 | 37.7350653972301 | -122.386317623483 | (37.7350653972301, -122.386317623483) | 10 | 3 | 8 | 58 | 1 | |||
29769 | 200551 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 27 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016216.4893 | 2095621.6927 | 37.735088399287 | -122.38634526793 | (37.735088399287, -122.38634526793) | 10 | 3 | 8 | 58 | 1 | |||
32807 | 175020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6010396.84323 | 2090323.76583 | 37.7202175482911 | -122.406092851014 | (37.7202175482911, -122.406092851014) | 10 | 3 | 8 | 309 | 28 | |||
34893 | 200562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 38 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016315.2256 | 2095489.7997 | 37.7347317124513 | -122.385994706933 | (37.7347317124513, -122.385994706933) | 10 | 3 | 8 | 58 | 1 | |||
35108 | 3688 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 2 | Median : Cutout | Tree | Port 6 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
35762 | 3690 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 4 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
37495 | 18550 | Landmark tree 11 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700X Quesada Ave | 5 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014656.2717 | 2095062.29209 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | 10 | 3 | 8 | 58 | 1 | |||
38953 | 3694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017199.673909 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | 10 | 3 | 8 | 58 | 1 | |||
39400 | 97226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.12769 | 37.7332433315076 | -122.384821485239 | (37.7332433315076, -122.384821485239) | 10 | 3 | 8 | 58 | 1 | ||
39780 | 200548 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 24 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016205.9984 | 2095634.3174 | 37.7351224834655 | -122.386382419007 | (37.7351224834655, -122.386382419007) | 10 | 3 | 8 | 58 | 1 | |||
43462 | 24278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350X Winding Way | 16 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000808.42529 | 2086790.57674 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | 9 | 7 | 6 | 28861 | 5 | |||
43641 | 200538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 14 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016175.1953 | 2095654.7768 | 37.7351769557335 | -122.386490343499 | (37.7351769557335, -122.386490343499) | 10 | 3 | 8 | 58 | 1 | |||
45428 | 443 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 5988815.98803 | 2110428.99683 | 37.7741905124987 | -122.482161976658 | (37.7741905124987, -122.482161976658) | 11 | 6 | 2 | 55 | 26 | ||||
45493 | 200568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 40 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016324.0126 | 2095472.2809 | 37.7346840956345 | -122.385963106208 | (37.7346840956345, -122.385963106208) | 10 | 3 | 8 | 58 | 1 | |||
46415 | 220273 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500x 27th St | 16 | Median : Cutout | Tree | DPW 1 | 23 | Width 4ft | 6002878.6956 | 2100066.19718 | 37.7465446697031 | -122.432776165093 | (37.7465446697031, -122.432776165093) | 2 | 7 | 5 | 63 | 22 | |||
47669 | 200540 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 16 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6016179.8101 | 2095650.1621 | 37.7351645401576 | -122.386474066655 | (37.7351645401576, -122.386474066655) | 10 | 3 | 8 | 58 | 1 | |||
48296 | 11709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.40868 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | 9 | 8 | 4 | 64 | 40 | ||
49929 | 448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5988818.05287 | 2110350.21953 | 37.7739743319878 | -122.482149061597 | (37.7739743319878, -122.482149061597) | 11 | 6 | 2 | 55 | 26 | ||||
51613 | 200518 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 1 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016087.5147 | 2095748.7503 | 37.7354301338826 | -122.386800041299 | (37.7354301338826, -122.386800041299) | 10 | 3 | 8 | 58 | 1 | |||
56647 | 21481 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2792X Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
59166 | 200544 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 20 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6016191.0622 | 2095640.0073 | 37.7351372799938 | -122.386434455904 | (37.7351372799938, -122.386434455904) | 10 | 3 | 8 | 58 | 1 | |||
60668 | 200609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 49 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | 10 | 3 | 8 | 58 | 1 | |||
61906 | 3693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017817.275253 | 2098336.256691 | 37.7426305289053 | -122.380999383309 | (37.7426305289053, -122.380999383309) | 10 | 3 | 8 | 58 | 1 | |||
61978 | 220272 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500x 27th St | 13 | Median : Cutout | Tree | DPW 1 | 10 | Width 4ft | 6002834.52979 | 2100065.92874 | 37.7465414276535 | -122.432928866369 | (37.7465414276535, -122.432928866369) | 2 | 7 | 5 | 63 | 22 | |||
62581 | 175058 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1132x Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | 9 | 7 | 6 | 28861 | 25 | |||
67366 | 200556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 32 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016262.7203 | 2095558.3918 | 37.734917146653 | -122.386181017716 | (37.734917146653, -122.386181017716) | 10 | 3 | 8 | 58 | 1 | |||
68498 | 200537 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 13 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6016177.7125 | 2095662.3283 | 37.735197829979 | -122.38648216691 | (37.735197829979, -122.38648216691) | 10 | 3 | 8 | 58 | 1 | |||
70659 | 4806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 | |||
72267 | 200610 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 50 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.7338361346818 | -122.385618942498 | (37.7338361346818, -122.385618942498) | 10 | 3 | 8 | 58 | 1 | |||
78663 | 200554 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 30 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6016223.9574 | 2095601.7778 | 37.7350341303539 | -122.386318059776 | (37.7350341303539, -122.386318059776) | 10 | 3 | 8 | 58 | 1 | |||
79364 | 4807 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Corona St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 35 | 5992988.2755218 | 2092740.8940691 | 37.7258653179999 | -122.466443562193 | (37.7258653179999, -122.466443562193) | 9 | 8 | 4 | 59 | 40 |
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) );