trees
40 rows where Police Districts = 7 and qSpecies_id = 53
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20606 | 15650 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3718 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005292.79028 | 2096596.92241 | 37.7371554485093 | -122.42418178869 | (37.7371554485093, -122.42418178869) | 2 | 7 | 5 | 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 | |||
| 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 | |||||
| 33092 | 92818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883 | 2096019 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | 9 | 7 | 4 | 59 | 40 | ||
| 34686 | 101290 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 830 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769326 | 6001055.4 | 2088979.9 | 37.7160006775821 | -122.438286819162 | (37.7160006775821, -122.438286819162) | 9 | 7 | 6 | 28861 | 5 | ||||
| 38445 | 4501 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | 2 | 7 | 5 | 63 | 22 | |||
| 57261 | 111200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 801x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | ||||
| 57759 | 4493 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.7450185306318 | -122.426882412261 | (37.7450185306318, -122.426882412261) | 2 | 7 | 5 | 63 | 22 | |||
| 61784 | 59066 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1658 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1980 12:00:00 AM | Permit Number 18361 | 6003975.177671 | 2098610.37486855 | 37.7426094440159 | -122.428880876877 | (37.7426094440159, -122.428880876877) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | ||||
| 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 | |||||
| 77697 | 26275 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1770 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 6000824.4471487 | 2093863.5491185 | 37.7293969298827 | -122.439434969516 | (37.7293969298827, -122.439434969516) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 82935 | 39773 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 |
| 83228 | 28249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
| 89944 | 108971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 20x ROUSSEAU ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003466 | 2095297.3 | 37.7334836652593 | -122.430405132046 | (37.7334836652593, -122.430405132046) | 2 | 7 | 5 | 28861 | 25 | ||||
| 103656 | 28250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
| 107111 | 44172 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 59 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | Permit Number 43639 | 6003760.97911216 | 2095401.48581894 | 37.733786440894 | -122.429392732684 | (37.733786440894, -122.429392732684) | 2 | 7 | 5 | 28861 | 25 | |||
| 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 | |||
| 112578 | 112394 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000472 | 2089324 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | 9 | 7 | 6 | 28861 | 5 | ||||
| 116920 | 39774 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1999 12:00:00 AM | 14 | 5.5x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 | |
| 122006 | 4883 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2X2 | 6000657.5251593 | 2098217.505729 | 37.7413423773337 | -122.440324154875 | (37.7413423773337, -122.440324154875) | 2 | 7 | 5 | 63 | 7 | |||
| 129658 | 5136 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2842 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 1x1 | 6002395.52907 | 2095496.33738 | 37.7339694804636 | -122.434120273378 | (37.7339694804636, -122.434120273378) | 2 | 7 | 5 | 63 | 7 | |||
| 140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
| 141296 | 15649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3718 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005292.79028 | 2096596.92241 | 37.7371554485093 | -122.42418178869 | (37.7371554485093, -122.42418178869) | 2 | 7 | 5 | 28859 | 2 | |||
| 142768 | 112396 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 574 VALLEY ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002248 | 2099192 | 37.7441085392299 | -122.434894531673 | (37.7441085392299, -122.434894531673) | 2 | 7 | 5 | 63 | 22 | ||||
| 144703 | 220211 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1399 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 7ft | 6005241 | 2100194 | 37.747029282671 | -122.424616654405 | (37.747029282671, -122.424616654405) | 2 | 7 | 5 | 28859 | 22 | |||
| 145671 | 15751 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4621 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002118.32394 | 2091946.54904 | 37.7242068323306 | -122.434824887315 | (37.7242068323306, -122.434824887315) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||
| 148900 | 57604 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 16491 | 5999828.22001193 | 2094390.77346711 | 37.7307878188175 | -122.442916855234 | (37.7307878188175, -122.442916855234) | 9 | 7 | 4 | 63 | 40 | ||
| 150324 | 702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1399X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005246.2674799 | 2100192.367786 | 37.74702509847 | -122.424598323807 | (37.74702509847, -122.424598323807) | 2 | 7 | 5 | 28859 | 22 | |||
| 160495 | 5728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1688 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005263.1161773 | 2098508.6699422 | 37.742402999925 | -122.42442032403 | (37.742402999925, -122.42442032403) | 2 | 7 | 5 | 63 | 22 | |||
| 161145 | 706 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1509X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005302.49516 | 2099477.85942 | 37.7450663972586 | -122.424353081707 | (37.7450663972586, -122.424353081707) | 2 | 7 | 5 | 28859 | 22 | |||
| 166856 | 95409 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Added tree to database on 2/28/11. Appears to be 15-20 yrs old. | 6002410 | 2095371 | 37.7336261540057 | -122.434061286386 | (37.7336261540057, -122.434061286386) | 2 | 7 | 5 | 63 | 7 | ||
| 170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | ||
| 178024 | 173876 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009764 | 2087931 | 37.7136120890563 | -122.408111727364 | (37.7136120890563, -122.408111727364) | 9 | 7 | 8 | 309 | 39 | ||||
| 181257 | 109235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002570.3 | 2095716.9 | 37.7345850124828 | -122.433531794387 | (37.7345850124828, -122.433531794387) | 2 | 7 | 5 | 63 | 7 | ||||
| 184670 | 59431 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3033 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 14 | 3x3 | Permit Number 18793 | 6002899.25612306 | 2096070.04882186 | 37.7355733371118 | -122.432419698468 | (37.7355733371118, -122.432419698468) | 2 | 7 | 5 | 63 | 7 |
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) );