trees
64 rows where PermitNotes = "" and qSpecies_id = 182
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2504 | 201613 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 3 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6020763.58395 | 2092982.86481 | 37.7280933269332 | -122.370441760089 | (37.7280933269332, -122.370441760089) | 10 | 3 | 8 | 58 | 1 | |||
12280 | 228353 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 3927 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004329.96792 | 2100710.39468 | 37.7483956894239 | -122.427803714594 | (37.7483956894239, -122.427803714594) | 2 | 4 | 5 | 63 | 22 | |||
12326 | 190626 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 1155 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015057.75881 | 2109472.8514 | 37.7730565307606 | -122.39131939457 | (37.7730565307606, -122.39131939457) | 14 | 3 | 9 | 310 | 20 | |||
19720 | 251256 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 4091x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991686 | 2086783 | 37.7094311644518 | -122.470511668938 | (37.7094311644518, -122.470511668938) | 9 | 8 | 4 | 64 | 24 | ||||
24206 | 228354 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 650 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009234.96967 | 2105386.50054 | 37.7615114767825 | -122.411172525907 | (37.7615114767825, -122.411172525907) | 2 | 4 | 7 | 28859 | 19 | |||
24757 | 138196 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 412 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005394.8315 | 2110818.7529 | 37.7762110317595 | -122.42484047597 | (37.7762110317595, -122.42484047597) | 7 | 9 | 11 | 28852 | 10 | |||
28589 | 228358 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 650 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009245.00145 | 2105258.31078 | 37.7611600595138 | -122.411128774784 | (37.7611600595138, -122.411128774784) | 2 | 4 | 7 | 28859 | 19 | |||
28819 | 228364 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 690 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009253.05651 | 2105058.10552 | 37.7606107931857 | -122.411086773758 | (37.7606107931857, -122.411086773758) | 2 | 4 | 7 | 28859 | 19 | |||
29571 | 219145 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993588.93723 | 2093444.60734 | 37.7278321844996 | -122.464418204256 | (37.7278321844996, -122.464418204256) | 9 | 8 | 4 | 59 | 40 | |||
38595 | 190618 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 1 Jack Balestreri Way | 32 | Front Yard : Yard | Tree | Private 2 | 10 | 6012380.89762 | 2104806.31927 | 37.7600943530021 | -122.40025123812 | (37.7600943530021, -122.40025123812) | 10 | 3 | 8 | 28856 | 29 | ||||
42981 | 228359 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 650 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009245.37699 | 2105202.37249 | 37.7610064867745 | -122.411123524554 | (37.7610064867745, -122.411123524554) | 2 | 4 | 7 | 28859 | 19 | |||
43826 | 228362 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 690 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009250.98012 | 2105080.31874 | 37.7606716691902 | -122.411095524149 | (37.7606716691902, -122.411095524149) | 2 | 4 | 7 | 28859 | 19 | |||
52041 | 116223 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 195 COLLINGWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002090 | 2104773 | 37.7594236635512 | -122.435840099174 | (37.7594236635512, -122.435840099174) | 2 | 4 | 5 | 28862 | 3 | |||
54791 | 199662 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 1375 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015149.5908 | 2090825.6295 | 37.7218602555285 | -122.389699078768 | (37.7218602555285, -122.389699078768) | 10 | 3 | 8 | 58 | 1 | |||
58824 | 199663 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 1375 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015172.7356 | 2090807.3573 | 37.7218113670572 | -122.389617796925 | (37.7218113670572, -122.389617796925) | 10 | 3 | 8 | 58 | 1 | |||
65605 | 248250 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 100 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006838.53158 | 2098969.7693 | 37.7437579135047 | -122.419005697381 | (37.7437579135047, -122.419005697381) | 2 | 7 | 7 | 28859 | 2 | |||
69225 | 190621 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011130.88671 | 2108006.09384 | 37.7688104311756 | -122.404799727536 | (37.7688104311756, -122.404799727536) | 8 | 2 | 8 | 28853 | 20 | |||
71510 | 201615 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 5 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6020732.10647 | 2093000.21976 | 37.728139252612 | -122.370551779534 | (37.728139252612, -122.370551779534) | 10 | 3 | 8 | 58 | 1 | |||
71767 | 228350 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 557 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002761.21744 | 2102085.63158 | 37.7520828972095 | -122.433326669795 | (37.7520828972095, -122.433326669795) | 2 | 4 | 5 | 28862 | 22 | |||
72240 | 244191 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 1850 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997685.6394 | 2108885.5737 | 37.770464572541 | -122.45136908078 | (37.770464572541, -122.45136908078) | 15 | 5 | 11 | 29492 | 9 | |||
72497 | 228365 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 690 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009254.87399 | 2105047.99063 | 37.7605831219216 | -122.411079773416 | (37.7605831219216, -122.411079773416) | 2 | 4 | 7 | 28859 | 19 | |||
74138 | 190623 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011128.17741 | 2108047.25299 | 37.7689232933915 | -122.404811996975 | (37.7689232933915, -122.404811996975) | 8 | 2 | 8 | 28853 | 20 | |||
77780 | 228360 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 680 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009245.21588 | 2105144.93329 | 37.7608487627785 | -122.411120024366 | (37.7608487627785, -122.411120024366) | 2 | 4 | 7 | 28859 | 19 | |||
78536 | 113248 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
78669 | 228357 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 650 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009240.17832 | 2105294.68845 | 37.7612596738224 | -122.411148025686 | (37.7612596738224, -122.411148025686) | 2 | 4 | 7 | 28859 | 19 | |||
79236 | 190620 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011131.86892 | 2107990.98095 | 37.7687689895213 | -122.404795265999 | (37.7687689895213, -122.404795265999) | 8 | 2 | 8 | 28853 | 20 | |||
79437 | 201614 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 4 | Side Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6020747.34365 | 2092993.8196 | 37.7281225153334 | -122.370498661104 | (37.7281225153334, -122.370498661104) | 10 | 3 | 8 | 58 | 1 | |||
80607 | 98485 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 531X Franconia St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
81837 | 228356 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 650 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009237.83277 | 2105328.49616 | 37.7613523705472 | -122.411158526152 | (37.7613523705472, -122.411158526152) | 2 | 4 | 7 | 28859 | 19 | |||
85069 | 190622 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011129.36426 | 2108026.35569 | 37.7688659805044 | -122.404806420291 | (37.7688659805044, -122.404806420291) | 8 | 2 | 8 | 28853 | 20 | |||
87491 | 98483 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 531X Franconia St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
88045 | 123941 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 139 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5993325.26746 | 2114563.46663 | 37.7858038926219 | -122.466864327641 | (37.7858038926219, -122.466864327641) | 11 | 6 | 2 | 54 | 11 | |||
96598 | 113249 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
99240 | 219144 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 1349 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991814.61663 | 2098388.03003 | 37.7413031402225 | -122.470911967708 | (37.7413031402225, -122.470911967708) | 1 | 8 | 4 | 59 | 40 | |||
102885 | 113242 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
107063 | 113250 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
110075 | 113247 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
110866 | 246820 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 198 Brewster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6010060.69624 | 2098737.22367 | 37.7433003114761 | -122.407847772774 | (37.7433003114761, -122.407847772774) | 2 | 7 | 7 | 28859 | 2 | ||||
111690 | 201612 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 2 | Side Yard : Yard | Tree | Private 2 | 2 | Width 3ft | 6020781.6072 | 2092974.15888 | 37.7280704113081 | -122.370378850726 | (37.7280704113081, -122.370378850726) | 10 | 3 | 8 | 58 | 1 | |||
113726 | 255619 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | ||||
116229 | 219143 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 225 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994147.21336 | 2105277.05568 | 37.7603532786058 | -122.463346523547 | (37.7603532786058, -122.463346523547) | 1 | 5 | 4 | 56 | 12 | |||
122286 | 190625 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011127.68527 | 2108086.43983 | 37.7690308640179 | -122.404816458515 | (37.7690308640179, -122.404816458515) | 8 | 2 | 8 | 28853 | 20 | |||
124916 | 201611 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 98 Jerrold Ave | 1 | Side Yard : Yard | Tree | Private 2 | 2 | Width 9ft | 6020793.34161 | 2092957.5019 | 37.7280253184122 | -122.370337132975 | (37.7280253184122, -122.370337132975) | 10 | 3 | 8 | 58 | 1 | |||
127543 | 113246 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
129622 | 228355 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 650 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009239.49246 | 2105360.20677 | 37.761439533729 | -122.411155025988 | (37.761439533729, -122.411155025988) | 2 | 4 | 7 | 28859 | 19 | |||
131943 | 228361 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 690 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009248.21276 | 2105093.47612 | 37.7607076411693 | -122.411106024639 | (37.7607076411693, -122.411106024639) | 2 | 4 | 7 | 28859 | 19 | |||
133691 | 4205 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 3912 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6004396.20206 | 2100464.83316 | 37.7477251809668 | -122.427557186127 | (37.7477251809668, -122.427557186127) | 2 | 4 | 5 | 63 | 22 | |||
143964 | 228349 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 583 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002614.94604 | 2102076.64 | 37.7520499091975 | -122.43383185498 | (37.7520499091975, -122.43383185498) | 2 | 4 | 5 | 28862 | 22 | |||
145883 | 251439 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 49X Eddy St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010285 | 2113564 | 37.7840238283003 | -122.408117626865 | (37.7840238283003, -122.408117626865) | 14 | 2 | 9 | 28852 | 36 | |||||
152894 | 113245 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
154092 | 228347 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 39 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006454.35209 | 2105651.71842 | 37.7620833700605 | -122.420808383909 | (37.7620833700605, -122.420808383909) | 8 | 4 | 7 | 28859 | 19 | |||
157448 | 4204 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 3912 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6004409.04709 | 2100465.80433 | 37.7477285741092 | -122.427512837863 | (37.7477285741092, -122.427512837863) | 2 | 4 | 5 | 63 | 22 | |||
159916 | 190619 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011132.20007 | 2107975.56033 | 37.7687266665196 | -122.404793034777 | (37.7687266665196, -122.404793034777) | 8 | 2 | 8 | 28853 | 20 | |||
172228 | 98475 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 531X Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
176767 | 228363 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 690 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009250.75381 | 2105069.23779 | 37.7606412307324 | -122.411095524132 | (37.7606412307324, -122.411095524132) | 2 | 4 | 7 | 28859 | 19 | |||
178685 | 228348 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 583 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002602.26695 | 2102075.05902 | 37.7520448487029 | -122.433875588106 | (37.7520448487029, -122.433875588106) | 2 | 4 | 5 | 28862 | 22 | |||
180790 | 98479 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 531X Franconia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
181023 | 113243 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
181260 | 98481 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 531X Franconia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
190499 | 98487 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 531X Franconia St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | 10 | 7 | 7 | 28859 | 2 | |||
190664 | 228351 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 4064 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003447.69274 | 2101289.13778 | 37.7499348332265 | -122.430895898552 | (37.7499348332265, -122.430895898552) | 2 | 4 | 5 | 28862 | 22 | |||
191845 | 113244 | Undocumented 4 | Gleditsia triacanthos :: Honey Locust 182 | 1301X 04TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5994883 | 2106671 | 37.7642230519674 | -122.46090282761 | (37.7642230519674, -122.46090282761) | 15 | 5 | 11 | 56 | 12 | ||||
192096 | 111385 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 340 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6014582.17665 | 2112417.55167 | 37.7811156101297 | -122.393170594161 | (37.7811156101297, -122.393170594161) | 6 | 2 | 9 | 28856 | 6 | |||
193762 | 190624 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 111 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011128.24066 | 2108066.19766 | 37.7689753146746 | -122.40481311214 | (37.7689753146746, -122.40481311214) | 8 | 2 | 8 | 28853 | 20 |
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) );