trees
390 rows where qSpecies_id = 126 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27526 | 254166 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5301 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5982204.13343 | 2111649.99569 | 37.7771562281008 | -122.505123677977 | (37.7771562281008, -122.505123677977) | 11 | 6 | 2 | 55 | 26 | ||||
71483 | 256066 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.389986064473 | (37.7225535544976, -122.389986064473) | 10 | 3 | 8 | 58 | 1 | ||||
144992 | 253609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 318 Utah St | 2 | Front Yard : Yard | Tree | Private 2 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
163809 | 253980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 433 Detroit St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.444331015365 | (37.7311859389748, -122.444331015365) | 9 | 7 | 4 | 59 | 40 | ||||
175137 | 119670 | Undocumented 4 | Yucca gloriosa :: Spanish Dagger 126 | 699x Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
17148 | 181306 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 469 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010294.74093 | 2089615.03342 | 37.7182658036088 | -122.406395873996 | (37.7182658036088, -122.406395873996) | 10 | 7 | 8 | 309 | 39 | |||
39249 | 137508 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 41 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001758.83711 | 2121302.73589 | 37.8047913017375 | -122.43816954959 | (37.8047913017375, -122.43816954959) | 13 | 9 | 1 | 57 | 17 | |||
80861 | 243975 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6007595.15715 | 2099522.63398 | 37.7453185340155 | -122.416428611787 | (37.7453185340155, -122.416428611787) | 2 | 7 | 7 | 28859 | 2 | ||||
116606 | 243961 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3725 26th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6005554.52967 | 2100776.99719 | 37.7486477612814 | -122.423573936807 | (37.7486477612814, -122.423573936807) | 2 | 4 | 5 | 28859 | 19 | |||
156813 | 117951 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4101 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5982854.39017 | 2110311.68646 | 37.7735198584795 | -122.502775180908 | (37.7735198584795, -122.502775180908) | 11 | 6 | 2 | 55 | 26 | |||
157827 | 202079 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962063 | -122.398009040306 | (37.721779962063, -122.398009040306) | 10 | 3 | 8 | 58 | 1 | ||||
3852 | 243986 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6008569.40583 | 2103127.50468 | 37.7552714408323 | -122.413314689443 | (37.7552714408323, -122.413314689443) | 2 | 4 | 7 | 28859 | 19 | |||
49460 | 119593 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3145 Cabrillo St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5985832.00278 | 2110410.03586 | 37.7739644387456 | -122.492482570938 | (37.7739644387456, -122.492482570938) | 11 | 6 | 2 | 55 | 26 | |||
68842 | 243984 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 18th St | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6009760.35156 | 2105514.40218 | 37.7618921157423 | -122.409364464996 | (37.7618921157423, -122.409364464996) | 8 | 4 | 8 | 28859 | 19 | |||
73318 | 243985 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 18th St | 6 | : | Tree | Private 2 | 11 | Width 2ft | 6009720.47366 | 2105510.67179 | 37.7618796385691 | -122.409502124237 | (37.7618796385691, -122.409502124237) | 8 | 4 | 8 | 28859 | 19 | |||
121475 | 217515 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 181 Staples Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998870.21413 | 2093813.74069 | 37.7291487568991 | -122.4461873294 | (37.7291487568991, -122.4461873294) | 9 | 7 | 4 | 28861 | 40 | ||||
128769 | 199528 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 695 Minnesota St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 2ft | 6015204.40478 | 2105547.51975 | 37.7622865664905 | -122.390537786585 | (37.7622865664905, -122.390537786585) | 10 | 3 | 8 | 28856 | 29 | |||
129090 | 199590 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2150 26th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6012089.24008 | 2101393.99303 | 37.7507085856518 | -122.401020184544 | (37.7507085856518, -122.401020184544) | 10 | 3 | 8 | 28856 | 29 | ||||
142381 | 217497 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Malta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999813.58139 | 2095851.10387 | 37.7347967097977 | -122.44307229994 | (37.7347967097977, -122.44307229994) | 9 | 7 | 4 | 63 | 40 | |||
144256 | 243981 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 80 | Front Yard : Yard | Tree | Private 2 | 11 | 6004609.84648 | 2096189.0617 | 37.7359969701789 | -122.426514004025 | (37.7359969701789, -122.426514004025) | 2 | 7 | 5 | 28861 | 2 | ||||
145566 | 122074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 347 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990561.10649 | 2113058.51415 | 37.7815117908068 | -122.476317478147 | (37.7815117908068, -122.476317478147) | 11 | 6 | 2 | 55 | 26 | |||
164125 | 243995 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 483 Valley St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6002806.73201 | 2099162.00018 | 37.7440578742739 | -122.432960419114 | (37.7440578742739, -122.432960419114) | 2 | 7 | 5 | 63 | 22 | ||||
172208 | 217518 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998600.75769 | 2093225.60072 | 37.7275184703858 | -122.447076550251 | (37.7275184703858, -122.447076550251) | 9 | 7 | 4 | 28861 | 40 | ||||
189662 | 246642 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 11 | 6009030.51293 | 2099210.21196 | 37.7445413057285 | -122.411443301892 | (37.7445413057285, -122.411443301892) | 2 | 7 | 7 | 28859 | 2 | ||||
638 | 217502 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 426 Hearst Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 10ft | 5998544.81231 | 2094412.25403 | 37.7307735449502 | -122.447355326608 | (37.7307735449502, -122.447355326608) | 9 | 7 | 4 | 59 | 40 | |||
7873 | 74275 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010944.70013 | 2088154.7138 | 37.714292400951 | -122.404046514754 | (37.714292400951, -122.404046514754) | 9 | 7 | 8 | 309 | 39 | |||
10920 | 32743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.19889 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) | 9 | 8 | 6 | 28861 | 24 |
10986 | 199613 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1650 Davidson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6014432.23191 | 2099824.22542 | 37.7465287570926 | -122.392808046859 | (37.7465287570926, -122.392808046859) | 10 | 3 | 8 | 58 | 1 | |||
13934 | 199608 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6016247.68812 | 2100671.01808 | 37.7489545425207 | -122.386589376117 | (37.7489545425207, -122.386589376117) | 10 | 3 | 8 | 58 | 1 | |||
18569 | 74063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010946.7362 | 2088147.19919 | 37.7142718811123 | -122.404038948741 | (37.7142718811123, -122.404038948741) | 9 | 7 | 8 | 309 | 39 | |||
22872 | 199568 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 680 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012064.94705 | 2105270.66031 | 37.7613517077453 | -122.401376599377 | (37.7613517077453, -122.401376599377) | 10 | 3 | 8 | 28856 | 29 | ||||
24752 | 199526 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6014906.74898 | 2105806.13827 | 37.7629801596351 | -122.391585356499 | (37.7629801596351, -122.391585356499) | 14 | 3 | 8 | 28856 | 29 | |||
30414 | 137512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3801 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002485.01335 | 2121661.73834 | 37.8058183005296 | -122.435682245137 | (37.8058183005296, -122.435682245137) | 13 | 9 | 1 | 57 | 17 | |||
32789 | 32956 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1218 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | 3x8 | Permit Number 37270 | 6013588.68321 | 2106187.45016 | 37.7639539086769 | -122.396170851203 | (37.7639539086769, -122.396170851203) | 14 | 3 | 8 | 28856 | 29 |
36481 | 199579 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2212 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6012144.74308 | 2101906.79924 | 37.7521197361546 | -122.400864273582 | (37.7521197361546, -122.400864273582) | 10 | 3 | 8 | 28856 | 29 | |||
40142 | 217534 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 167 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5992432.86148 | 2088983.12454 | 37.7155153350498 | -122.468090348403 | (37.7155153350498, -122.468090348403) | 9 | 8 | 6 | 64 | 24 | |||
40524 | 244015 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 74 Newburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002317.38718 | 2099770.68382 | 37.7457014087109 | -122.43469597844 | (37.7457014087109, -122.43469597844) | 2 | 7 | 5 | 63 | 22 | |||
48352 | 30689 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 529 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34609 | 6004554.59281 | 2110367.64108 | 37.7749248947896 | -122.427714942511 | (37.7749248947896, -122.427714942511) | 7 | 9 | 11 | 28852 | 10 | |
52808 | 199571 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 6012297.36216 | 2101934.2505 | 37.7522036231042 | -122.400338418383 | (37.7522036231042, -122.400338418383) | 10 | 3 | 8 | 28856 | 29 | ||||
80617 | 243996 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 483 Valley St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6002809.94275 | 2099165.62414 | 37.7440680069386 | -122.432949575959 | (37.7440680069386, -122.432949575959) | 2 | 7 | 5 | 63 | 22 | ||||
82713 | 26914 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.450354374056 | (37.7175236335794, -122.450354374056) | 9 | 8 | 6 | 28861 | 24 | |||
86485 | 108262 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6012679.64923 | 2090646.14976 | 37.7212301687063 | -122.398224504378 | (37.7212301687063, -122.398224504378) | 10 | 3 | 8 | 58 | 1 | ||||
106455 | 243990 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3250 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008996.81508 | 2099767.79019 | 37.7460704023351 | -122.411599210152 | (37.7460704023351, -122.411599210152) | 2 | 7 | 7 | 28859 | 2 | |||
109382 | 246640 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | 2 | 7 | 7 | 28859 | 2 | ||||
116538 | 199589 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6011296.13019 | 2104285.32637 | 37.7586032752312 | -122.403966287131 | (37.7586032752312, -122.403966287131) | 10 | 3 | 8 | 28856 | 29 | ||||
119577 | 199585 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 8ft | 6011335.71651 | 2104267.18906 | 37.7585556858141 | -122.4038281027 | (37.7585556858141, -122.4038281027) | 10 | 3 | 8 | 28856 | 29 | |||
125405 | 199545 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 1 | : Yard | Tree | Private 2 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.393496393361 | (37.7632512422621, -122.393496393361) | 14 | 3 | 8 | 28856 | 29 | ||||
133552 | 199527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 18th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 2ft | 6014914.45801 | 2105734.69881 | 37.7627844302812 | -122.391553698568 | (37.7627844302812, -122.391553698568) | 10 | 3 | 8 | 28856 | 29 | |||
138430 | 199622 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6014049.74697 | 2095137.71082 | 37.7336393102124 | -122.393802664676 | (37.7336393102124, -122.393802664676) | 10 | 3 | 8 | 58 | 1 | ||||
151620 | 246743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 140 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6008904.95931 | 2099075.94101 | 37.7441655842699 | -122.411867956365 | (37.7441655842699, -122.411867956365) | 2 | 7 | 7 | 28859 | 2 | ||||
161586 | 243971 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6006473.44341 | 2097229.56707 | 37.7389591427554 | -122.420144611411 | (37.7389591427554, -122.420144611411) | 2 | 7 | 7 | 28859 | 2 | |||
163621 | 92398 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1919 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52800 | 6012329.06895 | 2103729.70142 | 37.7571353073613 | -122.400354868801 | (37.7571353073613, -122.400354868801) | 10 | 3 | 8 | 28856 | 29 | |
168037 | 199591 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2250 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6011839.26664 | 2101391.56211 | 37.7506879632992 | -122.401884448303 | (37.7506879632992, -122.401884448303) | 10 | 3 | 8 | 28856 | 29 | ||||
8279 | 199563 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012717.44536 | 2104654.08234 | 37.7596951043532 | -122.399076586828 | (37.7596951043532, -122.399076586828) | 10 | 3 | 8 | 28856 | 29 | |||
31444 | 199600 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1500 22nd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6013491.56821 | 2103854.04221 | 37.7575414771611 | -122.396343185582 | (37.7575414771611, -122.396343185582) | 10 | 3 | 8 | 28856 | 29 | |||
133019 | 217503 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 426 Hearst Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 10ft | 5998540.33136 | 2094412.34729 | 37.7307735449633 | -122.447370824607 | (37.7307735449633, -122.447370824607) | 9 | 7 | 4 | 59 | 40 | |||
170277 | 199604 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 630 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | 6013529.78506 | 2104152.57114 | 37.7583632992371 | -122.396231937657 | (37.7583632992371, -122.396231937657) | 10 | 3 | 8 | 28856 | 29 | ||||
178235 | 243979 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 13 | 6004594.17707 | 2096179.38026 | 37.735969501297 | -122.426567490311 | (37.735969501297, -122.426567490311) | 2 | 7 | 5 | 28861 | 2 | ||||
178286 | 199594 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012053.10974 | 2101657.49367 | 37.751430085644 | -122.401163640783 | (37.751430085644, -122.401163640783) | 10 | 3 | 8 | 28856 | 29 | |||
29794 | 199606 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1515 19th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013141.4962 | 2105177.84105 | 37.7611568525403 | -122.397646731323 | (37.7611568525403, -122.397646731323) | 10 | 3 | 8 | 28856 | 29 | |||
106347 | 199609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 7ft | 6016246.85574 | 2100664.26356 | 37.7489359499297 | -122.386591783589 | (37.7489359499297, -122.386591783589) | 10 | 3 | 8 | 58 | 1 | |||
143474 | 217489 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1454 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 5ft | 5991178.64998 | 2105485.00303 | 37.7607527745534 | -122.473628468877 | (37.7607527745534, -122.473628468877) | 1 | 8 | 4 | 56 | 12 | |||
168539 | 181297 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 271 Prague St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6004070.03607 | 2089576.37759 | 37.7178094785893 | -122.427909293206 | (37.7178094785893, -122.427909293206) | 9 | 7 | 6 | 28861 | 5 | |||
9874 | 199550 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 6 | : Yard | Tree | Private 2 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | 14 | 3 | 8 | 28856 | 29 | ||||
25333 | 199595 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012041.40362 | 2101659.26991 | 37.7514343097479 | -122.401204246987 | (37.7514343097479, -122.401204246987) | 10 | 3 | 8 | 28856 | 29 | ||||
45886 | 243993 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 479 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003506.23365 | 2098907.96472 | 37.7434000031111 | -122.430523577396 | (37.7434000031111, -122.430523577396) | 2 | 7 | 5 | 63 | 22 | |||
90528 | 199552 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 8 | : Yard | Tree | Private 2 | 15 | 6014417.3246 | 2105922.3261 | 37.7632720076265 | -122.393286251461 | (37.7632720076265, -122.393286251461) | 14 | 3 | 8 | 28856 | 29 | ||||
93012 | 199547 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 3 | : Yard | Tree | Private 2 | 15 | 6014373.91679 | 2105917.88241 | 37.7632573945418 | -122.393436074922 | (37.7632573945418, -122.393436074922) | 14 | 3 | 8 | 28856 | 29 | ||||
104511 | 119969 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 540 28th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5987222.62788 | 2112233.92491 | 37.7790535307721 | -122.487806256895 | (37.7790535307721, -122.487806256895) | 11 | 6 | 2 | 55 | 26 | |||
105896 | 119968 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 540 28th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5987220.74694 | 2112250.93523 | 37.7791001265755 | -122.487814013837 | (37.7791001265755, -122.487814013837) | 11 | 6 | 2 | 55 | 26 | |||
108035 | 199601 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 22nd St | 18 | Front Yard : Yard | Tree | Private 2 | 15 | 6013350.80583 | 2103837.53278 | 37.757488311954 | -122.396828844671 | (37.757488311954, -122.396828844671) | 10 | 3 | 8 | 28856 | 29 | ||||
108225 | 199577 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 3 | Median : Yard | Tree | DPW 1 | 15 | 6012278.40127 | 2102219.77174 | 37.7529865450046 | -122.400424041944 | (37.7529865450046, -122.400424041944) | 10 | 3 | 8 | 28856 | 29 | ||||
118908 | 137511 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5999352.14411 | 2119120.73554 | 37.7986629462994 | -122.446341064008 | (37.7986629462994, -122.446341064008) | 13 | 9 | 1 | 57 | 17 | |||
121007 | 250140 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2550x Lyon St | 8 | Median : Yard | Tree | DPW 1 | 15 | 5999207.82154 | 2117620.05733 | 37.7945342406205 | -122.446732429154 | (37.7945342406205, -122.446732429154) | 13 | 1 | 57 | 30 | |||||
149914 | 199580 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 920 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 6011326.45045 | 2104017.48504 | 37.7578695363793 | -122.403842578193 | (37.7578695363793, -122.403842578193) | 10 | 3 | 8 | 28856 | 29 | |||
155531 | 199551 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 7 | : Yard | Tree | Private 2 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.393316411129 | (37.7632704697891, -122.393316411129) | 14 | 3 | 8 | 28856 | 29 | ||||
155705 | 117778 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 7414 Geary Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5983986.79106 | 2112513.36972 | 37.7796315288324 | -122.499020803345 | (37.7796315288324, -122.499020803345) | 11 | 6 | 2 | 55 | 26 | |||
169184 | 243988 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2766 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010155.45167 | 2102831.44612 | 37.754547449722 | -122.407808770075 | (37.754547449722, -122.407808770075) | 2 | 4 | 7 | 28859 | 19 | |||
178445 | 243997 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 483 Valley St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6002856.13849 | 2099166.37305 | 37.7440726834043 | -122.432789895044 | (37.7440726834043, -122.432789895044) | 2 | 7 | 5 | 63 | 22 | ||||
180454 | 181303 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 6 | Front Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 6013062.58437 | 2087561.0422 | 37.712780400456 | -122.396684633014 | (37.712780400456, -122.396684633014) | 10 | 3 | 8 | 58 | 1 | |||
22624 | 120087 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 401 26th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5987764.76806 | 2113165.69787 | 37.7816435236065 | -122.485999212153 | (37.7816435236065, -122.485999212153) | 11 | 6 | 2 | 55 | 26 | |||
77316 | 199614 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 53 | Median : Yard | Tree | DPW 1 | 16 | 6014257.65945 | 2095401.98638 | 37.7343765087595 | -122.393102330216 | (37.7343765087595, -122.393102330216) | 10 | 3 | 8 | 58 | 1 | ||||
122630 | 199621 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2330 Lane St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.393920294208 | (37.7276170037228, -122.393920294208) | 10 | 3 | 8 | 58 | 1 | ||||
131547 | 243973 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 5ft | 6006467.40316 | 2097218.12858 | 37.7389273948737 | -122.420164684273 | (37.7389273948737, -122.420164684273) | 2 | 7 | 7 | 28859 | 2 | |||
149096 | 51651 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 570 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | 16 | Permit Number 47934 | 5982889.2977 | 2111913.98983 | 37.7779213685412 | -122.502773063589 | (37.7779213685412, -122.502773063589) | 11 | 6 | 2 | 55 | 26 | ||
193936 | 200175 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1022 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6013884.9652 | 2089743.6718 | 37.7188192082582 | -122.393994895467 | (37.7188192082582, -122.393994895467) | 10 | 3 | 8 | 58 | 1 | |||
82286 | 199611 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6016252.0382 | 2100646.27412 | 37.748886841561 | -122.386572608245 | (37.748886841561, -122.386572608245) | 10 | 3 | 8 | 58 | 1 | |||
116287 | 217509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 100 Gennessee St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 1ft | 5997469.91402 | 2093889.34783 | 37.7292762870588 | -122.45103370846 | (37.7292762870588, -122.45103370846) | 9 | 7 | 4 | 28861 | 40 | |||
131658 | 199554 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 10 | : Yard | Tree | Private 2 | 17 | 6014431.68682 | 2105923.15598 | 37.7632750842003 | -122.393236634966 | (37.7632750842003, -122.393236634966) | 14 | 3 | 8 | 28856 | 29 | ||||
26204 | 84910 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5546 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2007 12:00:00 AM | 18 | Permit No. 49266 | 5981366.54955 | 2111678.1896 | 37.7771843232036 | -122.50802318732 | (37.7771843232036, -122.50802318732) | 11 | 6 | 2 | 55 | 26 | ||
46515 | 202076 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 5 | Front Yard : Yard | Tree | Private 2 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | 10 | 3 | 8 | 58 | 1 | ||||
60244 | 199531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1098 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014488.94971 | 2105281.88683 | 37.7615174797697 | -122.392993710091 | (37.7615174797697, -122.392993710091) | 10 | 3 | 8 | 28856 | 29 | ||||
77896 | 217537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 89 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 18 | 5992163.63598 | 2088434.33055 | 37.7139929276052 | -122.468980989298 | (37.7139929276052, -122.468980989298) | 9 | 8 | 6 | 64 | 24 | ||||
98598 | 243976 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 18 | 6004556.64322 | 2096143.57753 | 37.7358690730924 | -122.426694711107 | (37.7358690730924, -122.426694711107) | 2 | 7 | 5 | 28861 | 2 | ||||
114215 | 202075 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6012687.55592 | 2090674.96794 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | 10 | 3 | 8 | 58 | 1 | ||||
122473 | 217522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 143 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995315.51814 | 2090865.8028 | 37.7208507807174 | -122.458262844852 | (37.7208507807174, -122.458262844852) | 9 | 8 | 6 | 28861 | 24 | |||
129571 | 243991 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 285 Mullen Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010375.28221 | 2100026.37606 | 37.7468576499657 | -122.406850849112 | (37.7468576499657, -122.406850849112) | 2 | 7 | 7 | 28859 | 2 | |||
130546 | 217492 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1211 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5991111.74461 | 2105172.65449 | 37.7598912734774 | -122.473837074718 | (37.7598912734774, -122.473837074718) | 1 | 8 | 4 | 56 | 12 | |||
131503 | 202074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | 6012682.24985 | 2090663.29707 | 37.7212773966172 | -122.398216717151 | (37.7212773966172, -122.398216717151) | 10 | 3 | 8 | 58 | 1 | ||||
140547 | 217488 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1444 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5991174.83832 | 2105560.10023 | 37.7609587507553 | -122.473647129814 | (37.7609587507553, -122.473647129814) | 1 | 8 | 4 | 56 | 12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );