trees
150 rows where Supervisor Districts = 7 and qSpecies_id = 53 sorted by Location
This data as json, CSV (advanced)
These facets timed out: Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32689 | 108945 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
76306 | 108943 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
172873 | 33586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 248 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2006 12:00:00 AM | 3x3 | Permit Number 48813 | 6006863.32350459 | 2097675.63643968 | 37.7402059100197 | -122.418828210102 | (37.7402059100197, -122.418828210102) | 2 | 7 | 7 | 28859 | 2 | ||
70074 | 173891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007185 | 2099410 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | 2 | 7 | 7 | 28859 | 2 | ||||
145761 | 173892 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007185 | 2099410 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | 2 | 7 | 7 | 28859 | 2 | ||||
79797 | 113702 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 14 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
110718 | 113188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x12 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
64328 | 44245 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | 2 | 7 | 7 | 28859 | 2 | |||
140677 | 68840 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1506 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | Permit Number 32793 | 6009553.56622839 | 2100554.07443475 | 37.7482605801949 | -122.4097295193 | (37.7482605801949, -122.4097295193) | 2 | 4 | 7 | 28859 | 2 | |||
152427 | 112646 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3101 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008718 | 2100791 | 37.7488642652044 | -122.412635640211 | (37.7488642652044, -122.412635640211) | 2 | 4 | 7 | 28859 | 19 | |||
41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
133311 | 26518 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2881 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009034.88918 | 2101730.9691 | 37.7514629908808 | -122.411606237117 | (37.7514629908808, -122.411606237117) | 2 | 4 | 7 | 28859 | 19 | |||
40407 | 668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
51940 | 665 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
121805 | 669 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
156055 | 653 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.7522084236972 | -122.417764377532 | (37.7522084236972, -122.417764377532) | 2 | 4 | 7 | 28859 | 19 | |||
85308 | 631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
161467 | 632 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3179 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
19799 | 661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
138528 | 662 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
121432 | 624 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3157 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6007970.52254 | 2102065.21548 | 37.752320993709 | -122.415310615518 | (37.752320993709, -122.415310615518) | 2 | 4 | 7 | 28859 | 19 | |||
20430 | 647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
37666 | 646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
79861 | 649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
86183 | 645 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
119249 | 648 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
127611 | 618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3141X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.414962541065 | (37.7523835952977, -122.414962541065) | 2 | 4 | 7 | 28859 | 19 | |||
159897 | 617 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3141X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.414962541065 | (37.7523835952977, -122.414962541065) | 2 | 4 | 7 | 28859 | 19 | |||
34217 | 575 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.7524549543286 | -122.41222072227 | (37.7524549543286, -122.41222072227) | 2 | 4 | 7 | 28859 | 19 | |||
138573 | 603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3085 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008454.62539 | 2102106.73452 | 37.7524621916923 | -122.413639440921 | (37.7524621916923, -122.413639440921) | 2 | 4 | 7 | 28859 | 19 | |||
26891 | 601 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6008510.8606794 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | 2 | 4 | 7 | 28859 | 19 | ||||
138766 | 635 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3198 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007763.62302 | 2102126.97717 | 37.7524789468036 | -122.416030482711 | (37.7524789468036, -122.416030482711) | 2 | 4 | 7 | 28859 | 19 | |||
129162 | 615 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008105.60803 | 2102127.90457 | 37.7525007150423 | -122.414847903135 | (37.7525007150423, -122.414847903135) | 2 | 4 | 7 | 28859 | 19 | |||
179971 | 634 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3194 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 6007781.42285 | 2102140.57786 | 37.7525172919755 | -122.415969890792 | (37.7525172919755, -122.415969890792) | 2 | 4 | 7 | 28859 | 19 | |||
79982 | 628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007874.17365 | 2102144.23632 | 37.7525325514911 | -122.41564940087 | (37.7525325514911, -122.41564940087) | 2 | 4 | 7 | 28859 | 19 | |||
56222 | 121122 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
64233 | 121118 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
77226 | 121119 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
106064 | 121117 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
131499 | 121120 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
151070 | 121123 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
137374 | 585 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3035 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 122 | 3x3 | 6008718 | 2102146 | 37.7525847918351 | -122.412731419953 | (37.7525847918351, -122.412731419953) | 2 | 4 | 7 | 28859 | 19 | |||
126549 | 541 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009654.44601 | 2102141.49288 | 37.752624931831 | -122.409492696033 | (37.752624931831, -122.409492696033) | 2 | 4 | 7 | 28859 | 19 | |||
80355 | 588 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | 2 | 4 | 7 | 28859 | 19 | |||
178044 | 48952 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | 2 | 4 | 7 | 28859 | 19 | |
121361 | 506 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2773 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.7526526827318 | -122.407779587097 | (37.7526526827318, -122.407779587097) | 2 | 4 | 7 | 28859 | 19 | |||
152589 | 510 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2781 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.7526526827318 | -122.407779587097 | (37.7526526827318, -122.407779587097) | 2 | 4 | 7 | 28859 | 19 | |||
133502 | 583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3032 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008758.82346 | 2102183.24018 | 37.7526893362197 | -122.412592877178 | (37.7526893362197, -122.412592877178) | 2 | 4 | 7 | 28859 | 19 | |||
44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
115602 | 550 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2899 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009498.42946 | 2102171.88233 | 37.7526996313063 | -122.410034375932 | (37.7526996313063, -122.410034375932) | 2 | 4 | 7 | 28859 | 19 | |||
24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
169220 | 94550 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2851 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x5 | 6009753.55231 | 2102181.05227 | 37.7527391057434 | -122.40915275887 | (37.7527391057434, -122.40915275887) | 2 | 4 | 7 | 28859 | 19 | |||
76742 | 594 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008579.28838 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | 2 | 4 | 7 | 28859 | 19 | |||
70728 | 504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | 2 | 4 | 7 | 28859 | 19 | |||
172812 | 18468 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.406456244122 | (37.7528257474783, -122.406456244122) | 10 | 4 | 7 | 28859 | 19 | |||
127664 | 499 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2751 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010232.5569 | 2102206.4482 | 37.7528356605554 | -122.407498057365 | (37.7528356605554, -122.407498057365) | 2 | 4 | 7 | 28859 | 19 | |
43945 | 573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 776380 | 6009007.86528 | 2102243.77418 | 37.7528695228517 | -122.411735919997 | (37.7528695228517, -122.411735919997) | 2 | 4 | 7 | 28859 | 19 | ||
164080 | 570 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2972 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6009057.78841 | 2102246.54845 | 37.7528799408325 | -122.411563471864 | (37.7528799408325, -122.411563471864) | 2 | 4 | 7 | 28859 | 19 | |||
29987 | 578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008810.60715 | 2102251.62423 | 37.7528800095792 | -122.412418632597 | (37.7528800095792, -122.412418632597) | 2 | 4 | 7 | 28859 | 19 | |||
20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
191336 | 505 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.407649581645 | (37.7529538159215, -122.407649581645) | 2 | 4 | 7 | 28859 | 19 | |||
81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
145297 | 511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010123.24297 | 2102258.68458 | 37.7529729707581 | -122.407879770058 | (37.7529729707581, -122.407879770058) | 2 | 4 | 7 | 28859 | 19 | |||
142433 | 486 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.406523532023 | (37.7529942564805, -122.406523532023) | 10 | 4 | 7 | 28859 | 19 | |||
23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 | |||
64711 | 488 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
151621 | 482 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.7532012773937 | -122.406450377502 | (37.7532012773937, -122.406450377502) | 10 | 4 | 7 | 28859 | 19 | |||
33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
133106 | 18462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | 10 | 4 | 7 | 28859 | 19 | |||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
90722 | 56236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 147 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 24 | Permit Number 12362 | 6006719.97734959 | 2102927.77810186 | 37.7546190293471 | -122.419696406291 | (37.7546190293471, -122.419696406291) | 2 | 4 | 7 | 28859 | 19 | ||
165793 | 39111 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | 2 | 4 | 7 | 28859 | 19 | |
141160 | 18451 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396 | (37.7548433927728, -122.40664849396) | 10 | 4 | 7 | 28859 | 19 | |||
99827 | 109850 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3250x 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
139905 | 18447 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1036 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6010477.6303584 | 2103193.8225196 | 37.7555604859056 | -122.406720122129 | (37.7555604859056, -122.406720122129) | 10 | 4 | 7 | 28859 | 19 | |||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
106094 | 117567 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2498 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008843 | 2103923 | 37.7574710478396 | -122.41242474225 | (37.7574710478396, -122.41242474225) | 2 | 4 | 7 | 28859 | 19 | |||
118796 | 65046 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2498 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1989 12:00:00 AM | 18 | Permit Number 26099 | 6008837.93100399 | 2103923.47328543 | 37.7574720629103 | -122.412442306383 | (37.7574720629103, -122.412442306383) | 2 | 4 | 7 | 28859 | 19 | ||
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
99014 | 117566 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
169697 | 117565 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
158510 | 18390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | 10 | 4 | 7 | 28859 | 19 | |||
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
97918 | 102451 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | |||
55414 | 61158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) | 2 | 4 | 7 | 28859 | 19 |
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
64858 | 102457 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
119605 | 102455 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
133761 | 102454 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
111614 | 87145 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
172669 | 87144 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 |
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) );