trees
332 rows where qSpecies_id = 121 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74995 | 89466 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3700 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987138.86697 | 2111884.81108 | 37.7780900770152 | -122.488070356177 | (37.7780900770152, -122.488070356177) | 11 | 6 | 2 | 55 | 26 | ||
82641 | 64058 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3700 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1987 12:00:00 AM | 5 | Permit Number 24817 | 5987163.87734 | 2111884.56933 | 37.7780908722437 | -122.487983819675 | (37.7780908722437, -122.487983819675) | 11 | 6 | 2 | 55 | 26 | ||
99276 | 120304 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988688.31832 | 2114612.78374 | 37.7856705904605 | -122.482910293069 | (37.7856705904605, -122.482910293069) | 11 | 6 | 2 | 55 | 26 | |||
143205 | 120306 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988689.7691 | 2114567.26931 | 37.7855457051568 | -122.482901936944 | (37.7855457051568, -122.482901936944) | 11 | 6 | 2 | 55 | 26 | |||
120094 | 120305 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988689.97406 | 2114597.66035 | 37.7856291622608 | -122.482903455976 | (37.7856291622608, -122.482903455976) | 11 | 6 | 2 | 55 | 26 | |||
40347 | 120307 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988691.32321 | 2114547.33744 | 37.7854910683194 | -122.482895098939 | (37.7854910683194, -122.482895098939) | 11 | 6 | 2 | 55 | 26 | |||
152221 | 120476 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2153 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5988709.31254 | 2114650.77812 | 37.7857761337969 | -122.482840445446 | (37.7857761337969, -122.482840445446) | 11 | 6 | 2 | 55 | 26 | |||
171528 | 120475 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2153 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5988722.30623 | 2114650.77246 | 37.7857768742694 | -122.482795491067 | (37.7857768742694, -122.482795491067) | 11 | 6 | 2 | 55 | 26 | |||
100357 | 11657 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
6276 | 11636 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
89514 | 11634 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
51556 | 124030 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991790.36528 | 2114364.58828 | 37.7851691212148 | -122.472160105538 | (37.7851691212148, -122.472160105538) | 11 | 6 | 2 | 54 | 11 | |||
47067 | 59141 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 588 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18448 | 5992243.78964 | 2111491.996 | 37.7773079985249 | -122.470382138383 | (37.7773079985249, -122.470382138383) | 11 | 6 | 2 | 54 | 11 | ||
132736 | 59144 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 690 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18451 | 5992269.28731 | 2110774.72924 | 37.7753400527011 | -122.470241689466 | (37.7753400527011, -122.470241689466) | 11 | 6 | 2 | 54 | 11 | ||
95732 | 218966 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 255 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992657.85366 | 2095112.02317 | 37.7323567798226 | -122.467758171218 | (37.7323567798226, -122.467758171218) | 9 | 8 | 4 | 59 | 40 | |||
54925 | 56313 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 229 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12447 | 5993040.18993 | 2113916.11955 | 37.7840099974474 | -122.467803508187 | (37.7840099974474, -122.467803508187) | 11 | 6 | 2 | 54 | 11 | ||
159188 | 68672 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 260 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32580 | 5993093.46375 | 2113748.31872 | 37.7835523382358 | -122.467606994541 | (37.7835523382358, -122.467606994541) | 11 | 6 | 2 | 54 | 11 | |
69935 | 107514 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 76 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x10 | 5993384 | 2099214 | 37.7436616846124 | -122.4655456274 | (37.7436616846124, -122.4655456274) | 1 | 8 | 4 | 29491 | 40 | |||
57801 | 59099 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 488 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18401 | 5993459.27292 | 2112191.28378 | 37.7792982564624 | -122.466228254831 | (37.7792982564624, -122.466228254831) | 11 | 6 | 2 | 54 | 11 | ||
156488 | 59101 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 654 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18403 | 5993502.53489 | 2111016.0685 | 37.7760739276641 | -122.465993175595 | (37.7760739276641, -122.465993175595) | 11 | 6 | 2 | 54 | 11 | ||
98908 | 218975 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 25 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993599.79076 | 2092994.21987 | 37.7265961562865 | -122.464347997761 | (37.7265961562865, -122.464347997761) | 9 | 8 | 4 | 59 | 40 | |||
23260 | 218969 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.7503932752257 | -122.464965376055 | (37.7503932752257, -122.464965376055) | 1 | 8 | 4 | 29491 | 40 | |||
87845 | 218968 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 150 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5993617.45125 | 2101661.58733 | 37.7503955999976 | -122.464916133678 | (37.7503955999976, -122.464916133678) | 1 | 8 | 4 | 29491 | 40 | |||
4759 | 218967 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 140 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993644.45362 | 2101662.07824 | 37.7503985047832 | -122.464822793961 | (37.7503985047832, -122.464822793961) | 1 | 8 | 4 | 29491 | 40 | |||
181729 | 218974 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5995324.88397 | 2091369.23318 | 37.7222336187729 | -122.458266889107 | (37.7222336187729, -122.458266889107) | 9 | 8 | 4 | 28861 | 24 | |||
98603 | 218977 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 5996588.22406 | 2105623.74561 | 37.761445530401 | -122.454929303567 | (37.761445530401, -122.454929303567) | 15 | 5 | 11 | 29492 | 12 | |||
109256 | 225789 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 409 Dellbrook Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997048.20072 | 2102795.35511 | 37.7537058578562 | -122.453134258532 | (37.7537058578562, -122.453134258532) | 1 | 5 | 4 | 63 | 38 | |||
47364 | 218970 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 85 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997504.5128 | 2099195.16066 | 37.7438467530404 | -122.451296605465 | (37.7438467530404, -122.451296605465) | 9 | 7 | 4 | 59 | 40 | |||
120312 | 218971 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 736 Myra Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997513.55349 | 2097982.45512 | 37.7405174763054 | -122.451177906656 | (37.7405174763054, -122.451177906656) | 9 | 7 | 4 | 59 | 40 | |||
131691 | 56260 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 238 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | Permit Number 12386 | 5997570.92464879 | 2106477.05534424 | 37.7638448267197 | -122.451592119849 | (37.7638448267197, -122.451592119849) | 15 | 5 | 11 | 29492 | 9 | |||
182398 | 244215 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997712.0535 | 2108841.8253 | 37.7703459631123 | -122.451274559097 | (37.7703459631123, -122.451274559097) | 15 | 5 | 11 | 29492 | 9 | |||
104963 | 96698 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
166785 | 218973 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 550 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5997760.19795 | 2094413.18303 | 37.7307312291661 | -122.450067916609 | (37.7307312291661, -122.450067916609) | 9 | 7 | 4 | 59 | 40 | |||
111725 | 248584 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5998013.4865 | 2107655.5885 | 37.7671061143032 | -122.450146392184 | (37.7671061143032, -122.450146392184) | 15 | 5 | 11 | 29492 | 9 | |||
124022 | 98345 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998016 | 2107622 | 37.767014032658 | -122.45013527715 | (37.767014032658, -122.45013527715) | 15 | 5 | 11 | 29492 | 9 | ||||
162422 | 115825 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 403 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998362 | 2109233 | 37.7714572219689 | -122.449054588277 | (37.7714572219689, -122.449054588277) | 15 | 5 | 11 | 29492 | 9 | ||||
93967 | 225389 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 811 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998617.86055 | 2107510.18613 | 37.7667414427907 | -122.448045492407 | (37.7667414427907, -122.448045492407) | 15 | 5 | 11 | 29492 | 9 | |||
80622 | 225778 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 924 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5998777.43857 | 2106776.2154 | 37.7647352648411 | -122.447440705541 | (37.7647352648411, -122.447440705541) | 15 | 5 | 11 | 29492 | 9 | |||
107520 | 113749 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 459 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998867 | 2109101 | 37.7711236529318 | -122.447298272426 | (37.7711236529318, -122.447298272426) | 15 | 5 | 11 | 29492 | 9 | ||||
142112 | 14548 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 815 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2000 12:00:00 AM | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.7736546990505 | -122.44626515618 | (37.7736546990505, -122.44626515618) | 15 | 5 | 11 | 29492 | 16 | ||
156867 | 14546 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 815 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.7736546990505 | -122.44626515618 | (37.7736546990505, -122.44626515618) | 15 | 5 | 11 | 29492 | 16 | |||
159131 | 225790 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 920 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999222.99784 | 2106999.85397 | 37.7653747718527 | -122.445915724224 | (37.7653747718527, -122.445915724224) | 15 | 5 | 5 | 29492 | 9 | |||
123217 | 225791 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 920 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999226.76064 | 2106974.09226 | 37.765304251518 | -122.445900856638 | (37.765304251518, -122.445900856638) | 15 | 5 | 5 | 29492 | 9 | |||
114871 | 247293 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1187 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5999369.2896 | 2108822.0623 | 37.7703864492561 | -122.445540779928 | (37.7703864492561, -122.445540779928) | 15 | 5 | 11 | 29492 | 9 | |||
150760 | 116066 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 40 MALTA DR | Median : Cutout | Tree | DPW 1 | 10 | 5999623 | 2096071 | 37.7353896244756 | -122.443746996044 | (37.7353896244756, -122.443746996044) | 9 | 7 | 4 | 63 | 40 | |||||
139494 | 225779 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1559 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999770.51083 | 2107118.59811 | 37.7657320617173 | -122.444030542889 | (37.7657320617173, -122.444030542889) | 15 | 5 | 5 | 29492 | 9 | |||
154444 | 128809 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | 13 | 9 | 1 | 57 | 27 | |||
3372 | 218976 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 208 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000663.81639 | 2094977.92785 | 37.7324476131567 | -122.440070159711 | (37.7324476131567, -122.440070159711) | 9 | 7 | 5 | 63 | 40 | |||
60626 | 225817 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 220 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000861.2218 | 2106493.57318 | 37.7640780573843 | -122.440213192391 | (37.7640780573843, -122.440213192391) | 15 | 5 | 5 | 28862 | 3 | |||
48957 | 225816 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 220 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000887.34044 | 2106474.16774 | 37.7640262618211 | -122.440121464252 | (37.7640262618211, -122.440121464252) | 15 | 5 | 5 | 28862 | 3 | |||
159728 | 225788 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4436 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001105.5651 | 2101159.8137 | 37.7494467567732 | -122.43898580666 | (37.7494467567732, -122.43898580666) | 2 | 4 | 5 | 28862 | 22 | |||
22122 | 128808 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001383.33039 | 2116587.25055 | 37.7918224564007 | -122.439130852904 | (37.7918224564007, -122.439130852904) | 13 | 6 | 1 | 29490 | 27 | |||
48366 | 225804 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4433 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001581.80688 | 2104063.4307 | 37.7574464772949 | -122.437546862602 | (37.7574464772949, -122.437546862602) | 2 | 4 | 5 | 28862 | 3 | |||
116349 | 985 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1628 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6001654.08898 | 2092682.1975 | 37.7262003881553 | -122.436482304747 | (37.7262003881553, -122.436482304747) | 9 | 7 | 6 | 28861 | 25 | |||
118187 | 83898 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 661 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50511 | 6001665.34461 | 2093208.93849 | 37.7276473387373 | -122.436481078764 | (37.7276473387373, -122.436481078764) | 9 | 7 | 6 | 28861 | 25 | |
190745 | 225802 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 372 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001775.08554 | 2103686.11524 | 37.7564214471208 | -122.436851418666 | (37.7564214471208, -122.436851418666) | 2 | 4 | 5 | 28862 | 3 | |||
52573 | 225803 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 378 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001778.51091 | 2103657.66309 | 37.7563435190568 | -122.436837535831 | (37.7563435190568, -122.436837535831) | 2 | 4 | 5 | 28862 | 3 | |||
56172 | 41689 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.4652313 | 2096668.95095007 | 37.7371560974157 | -122.436219989049 | (37.7371560974157, -122.436219989049) | 2 | 7 | 5 | 63 | 7 | |||
81032 | 225806 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 363 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001815.68909 | 2103737.40207 | 37.7565645760008 | -122.43671466866 | (37.7565645760008, -122.43671466866) | 2 | 4 | 5 | 28862 | 3 | |||
9452 | 225805 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 367 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001818.89494 | 2103707.75244 | 37.7564833474558 | -122.436701459403 | (37.7564833474558, -122.436701459403) | 2 | 4 | 5 | 28862 | 3 | |||
184710 | 225815 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 815 Duboce Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 6001846.90883 | 2108236.07795 | 37.768918616038 | -122.436928749563 | (37.768918616038, -122.436928749563) | 15 | 5 | 5 | 29492 | 3 | |||
142474 | 225801 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4201 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001928.34635 | 2105251.90853 | 37.7607294461137 | -122.43643345245 | (37.7607294461137, -122.43643345245) | 2 | 4 | 5 | 28862 | 3 | |||
17089 | 225807 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x5 | 6002846.79255 | 2107449.48757 | 37.7668156107901 | -122.433414004758 | (37.7668156107901, -122.433414004758) | 15 | 5 | 5 | 28862 | 3 | |||
154127 | 16624 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 143 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x5 | 6002878.48419 | 2107471.64141 | 37.7668782377669 | -122.4333059719 | (37.7668782377669, -122.4333059719) | 15 | 5 | 5 | 28862 | 3 | |||
94180 | 225813 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 159 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6002885.55761 | 2107343.69078 | 37.7665273178175 | -122.43327236244 | (37.7665273178175, -122.43327236244) | 15 | 5 | 5 | 28862 | 3 | |||
103522 | 16637 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 159 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002887.79495 | 2107329.82108 | 37.7664893619256 | -122.433263632733 | (37.7664893619256, -122.433263632733) | 15 | 5 | 5 | 28862 | 3 | |||
93940 | 16628 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 147 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2006 12:00:00 AM | 12 | 3X3 | 6002889.82891 | 2107449.635 | 37.7668184571199 | -122.433265159761 | (37.7668184571199, -122.433265159761) | 15 | 5 | 5 | 28862 | 3 | ||
91445 | 16635 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 153 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6002890.76164 | 2107366.51768 | 37.7665902901414 | -122.43325599389 | (37.7665902901414, -122.43325599389) | 15 | 5 | 5 | 28862 | 3 | |||
94096 | 225814 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 159 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002898.26283 | 2107347.8267 | 37.7665393948003 | -122.433228712945 | (37.7665393948003, -122.433228712945) | 15 | 5 | 5 | 28862 | 3 | |||
158671 | 225809 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 197 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002900.20105 | 2107141.3628 | 37.7659726051812 | -122.433207255136 | (37.7659726051812, -122.433207255136) | 15 | 5 | 5 | 28862 | 3 | |||
88556 | 225810 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 197 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6002901.37283 | 2107162.40051 | 37.7660304360828 | -122.433204705528 | (37.7660304360828, -122.433204705528) | 15 | 5 | 5 | 28862 | 3 | |||
116220 | 225811 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 197 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002903.22213 | 2107175.55757 | 37.766066667072 | -122.433199249367 | (37.766066667072, -122.433199249367) | 15 | 5 | 5 | 28862 | 3 | |||
61347 | 225812 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 197 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6002912.30789 | 2107203.01713 | 37.7661425797454 | -122.43316978577 | (37.7661425797454, -122.43316978577) | 15 | 5 | 5 | 28862 | 3 | |||
39859 | 225383 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 464 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002919.07295 | 2099218.44031 | 37.7442192171504 | -122.432576000288 | (37.7442192171504, -122.432576000288) | 2 | 7 | 5 | 63 | 22 | |||
176861 | 225808 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 67 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6003135.12439 | 2107389.88672 | 37.766668315309 | -122.432412455892 | (37.766668315309, -122.432412455892) | 15 | 5 | 5 | 28862 | 3 | |||
148986 | 2681 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2085 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2015 12:00:00 AM | 22 | 3X3 | 6003609.80751 | 2114718.21117 | 37.7868169864691 | -122.431293772174 | (37.7868169864691, -122.431293772174) | 13 | 9 | 11 | 29490 | 27 | ||
158683 | 2680 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2085 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2015 12:00:00 AM | 19 | 3X3 | 6003616.3325 | 2114868.6836 | 37.7872305155325 | -122.43128194219 | (37.7872305155325, -122.43128194219) | 13 | 9 | 11 | 29490 | 27 | ||
14434 | 225800 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 839 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003765.43327 | 2103426.88271 | 37.7558225759747 | -122.429949607592 | (37.7558225759747, -122.429949607592) | 2 | 4 | 5 | 28862 | 22 | |||
108672 | 128810 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2619 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003992.93502 | 2117891.72487 | 37.7955523541042 | -122.430194727727 | (37.7955523541042, -122.430194727727) | 13 | 9 | 1 | 29490 | 27 | |||
117180 | 225799 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3965 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004086.71679 | 2101282.70984 | 37.7499533700549 | -122.428685663533 | (37.7499533700549, -122.428685663533) | 2 | 4 | 5 | 28862 | 22 | |||
164524 | 225787 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 46 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004400.60318 | 2095343.96322 | 37.7336646890731 | -122.42717726484 | (37.7336646890731, -122.42717726484) | 2 | 7 | 5 | 28861 | 25 | |||
18685 | 225385 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004766.71932 | 2101872.10114 | 37.7516101631948 | -122.426376138857 | (37.7516101631948, -122.426376138857) | 2 | 4 | 5 | 28862 | 22 | |||
88230 | 225388 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 306 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6004766.97912 | 2101818.89406 | 37.75146408361 | -122.426371452475 | (37.75146408361, -122.426371452475) | 2 | 4 | 5 | 28862 | 22 | |||
25853 | 225384 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004767.45942 | 2101889.24161 | 37.7516572687753 | -122.426374799776 | (37.7516572687753, -122.426374799776) | 2 | 4 | 5 | 28862 | 22 | |||
69577 | 225386 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004769.89273 | 2101857.00053 | 37.7515688798154 | -122.426364089745 | (37.7515688798154, -122.426364089745) | 2 | 4 | 5 | 28862 | 22 | |||
52048 | 225387 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | 2 | 4 | 5 | 28862 | 22 | |||
113356 | 51032 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 78 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47507 | 6004848.23489 | 2092967.46404 | 37.7271646546122 | -122.425460601145 | (37.7271646546122, -122.425460601145) | 9 | 7 | 6 | 28861 | 5 | ||
188185 | 51033 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 76 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47508 | 6004871.9247 | 2093005.45041 | 37.7272702952631 | -122.42538140772 | (37.7272702952631, -122.42538140772) | 9 | 7 | 6 | 28861 | 5 | ||
61981 | 225382 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005452.14403 | 2105496.18029 | 37.7615997596391 | -122.424263576509 | (37.7615997596391, -122.424263576509) | 8 | 4 | 5 | 28859 | 19 | |||
64625 | 64914 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.3629861 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | 2 | 7 | 5 | 28859 | 22 | |
190161 | 252991 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005528 | 2099293 | 37.7445715466522 | -122.423560184697 | (37.7445715466522, -122.423560184697) | 2 | 7 | 5 | 28859 | 22 | ||||
130918 | 225784 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 98 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005770.92499 | 2103464.55154 | 37.7560393773435 | -122.423016636805 | (37.7560393773435, -122.423016636805) | 2 | 4 | 5 | 28859 | 19 | |||
85835 | 225818 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 98 Hill St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005774.11943 | 2103465.5032 | 37.7560421706386 | -122.423005656989 | (37.7560421706386, -122.423005656989) | 2 | 4 | 5 | 28859 | 19 | |||
113940 | 225785 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 96 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005776.35688 | 2103464.45432 | 37.7560394169139 | -122.422997844584 | (37.7560394169139, -122.422997844584) | 2 | 4 | 5 | 28859 | 19 | |||
157447 | 225786 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 94 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005786.79673 | 2103464.50998 | 37.7560401588409 | -122.422961744009 | (37.7560401588409, -122.422961744009) | 2 | 4 | 5 | 28859 | 19 | |||
53565 | 92547 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.421093271685 | (37.740071660795, -122.421093271685) | 2 | 7 | 7 | 28859 | 2 | |||
193366 | 33475 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432 | 2098629 | 37.7427993369958 | -122.420387207052 | (37.7427993369958, -122.420387207052) | 2 | 7 | 7 | 28859 | 2 | ||
51889 | 33479 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
87961 | 33480 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
145418 | 33476 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 |
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) );