trees
1,985 rows where qSpecies_id = 83 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146392 | 9980 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 810X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 24 | 3X3 | Permit Number 54082 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | 15 | 9 | 11 | 29492 | 10 | |
130885 | 9979 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | 15 | 9 | 11 | 29492 | 10 | |
15862 | 99761 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485 | 2101232 | 37.7497233531083 | -122.434220849449 | (37.7497233531083, -122.434220849449) | 2 | 4 | 5 | 28862 | 22 | |||
145775 | 99598 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | 13 | 9 | 1 | 57 | 17 | |||
125315 | 99597 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3001@Filbert Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
89508 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 401X Newhall St | 1 | Front Yard : | Tree | Private 2 | 6 | 3x3 | 6016081.14502 | 2097910.94016 | 37.7413667159929 | -122.386972815546 | (37.7413667159929, -122.386972815546) | 10 | 3 | 8 | 58 | 1 | |||
129559 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 766 Anderson St | Front Yard : Yard | Tree | Private 2 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723 | 2095324 | 37.7337971999422 | -122.415689321062 | (37.7337971999422, -122.415689321062) | 2 | 7 | 7 | 28859 | 2 | |||
133479 | 98121 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 900 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | ||
102681 | 97759 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1699X Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014853.3 | 2094854.4 | 37.7329060184543 | -122.391004730192 | (37.7329060184543, -122.391004730192) | 10 | 3 | 8 | 58 | 1 | |||
60223 | 97605 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 445 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768351 | 6005728.0342 | 2111001.8882 | 37.7767326912067 | -122.423700859813 | (37.7767326912067, -122.423700859813) | 7 | 9 | 11 | 28852 | 10 | |
124854 | 97604 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 445 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2011 12:00:00 AM | 2 | 3x5 | Permit Number 768351 | 6005714.1676 | 2110999.8082 | 37.7767261972703 | -122.423748680625 | (37.7767261972703, -122.423748680625) | 7 | 9 | 11 | 28852 | 10 | |
29594 | 96720 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
26378 | 96719 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
10982 | 96718 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | ||
78648 | 96161 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 6 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767793 | 6003680 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | 2 | 7 | 5 | 28861 | 25 | |
146564 | 96122 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 234 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093 | 2096944 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | 2 | 7 | 7 | 28859 | 2 | |
58661 | 96121 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 234 Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093 | 2096944 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | 2 | 7 | 7 | 28859 | 2 | |
148405 | 96109 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | 3x3 | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | ||
187897 | 96107 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2780X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865922 | (37.7618258328219, -122.40992865922) | 8 | 4 | 8 | 28859 | 19 | ||
40583 | 96102 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865922 | (37.7618258328219, -122.40992865922) | 8 | 4 | 8 | 28859 | 19 | ||
120291 | 96100 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2780X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865922 | (37.7618258328219, -122.40992865922) | 8 | 4 | 8 | 28859 | 19 | ||
110213 | 96097 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009553 | 2105475 | 37.7617723065941 | -122.410078833483 | (37.7617723065941, -122.410078833483) | 8 | 4 | 8 | 28859 | 19 | ||
70431 | 96064 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767689 | 6007344.9 | 2099669.6 | 37.7457079931938 | -122.417304374627 | (37.7457079931938, -122.417304374627) | 2 | 7 | 7 | 28859 | 2 | |
30163 | 96054 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1261 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767682 | 6009524 | 2101832 | 37.7517678233481 | -122.409921957152 | (37.7517678233481, -122.409921957152) | 2 | 4 | 7 | 28859 | 19 | |
10528 | 96053 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | 2 | 7 | 7 | 28859 | 2 | |
92566 | 96052 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 130 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | 2 | 7 | 7 | 28859 | 2 | |
187914 | 96049 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324 | 2099841 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | 2 | 7 | 7 | 28859 | 2 | |
41317 | 96048 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324 | 2099841 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | 2 | 7 | 7 | 28859 | 2 | |
67121 | 96047 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324 | 2099841 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | 2 | 7 | 7 | 28859 | 2 | |
132439 | 95867 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 733 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767588 | 6008296.37826 | 2120666.6947 | 37.8034145323264 | -122.415500582505 | (37.8034145323264, -122.415500582505) | 5 | 1 | 10 | 308 | 32 |
103091 | 95815 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 691 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464 | 2105840 | 37.7631040519916 | -122.389660365218 | (37.7631040519916, -122.389660365218) | 14 | 3 | 8 | 28856 | 29 | |
170043 | 95814 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 691 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464 | 2105840 | 37.7631040519916 | -122.389660365218 | (37.7631040519916, -122.389660365218) | 14 | 3 | 8 | 28856 | 29 | |
122272 | 95812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 691 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464 | 2105840 | 37.7631040519916 | -122.389660365218 | (37.7631040519916, -122.389660365218) | 14 | 3 | 8 | 28856 | 29 | |
193699 | 95794 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767537 | 6010317 | 2101466 | 37.7508072797373 | -122.407153846535 | (37.7508072797373, -122.407153846535) | 2 | 4 | 7 | 28859 | 19 | |
136165 | 95789 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3631 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767532 | 6006103.9 | 2100790.8 | 37.7487166547031 | -122.421675197163 | (37.7487166547031, -122.421675197163) | 2 | 4 | 5 | 28859 | 19 | |
25796 | 95782 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3619 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767526 | 6005487 | 2104873 | 37.7598906214089 | -122.424098704222 | (37.7598906214089, -122.424098704222) | 2 | 4 | 5 | 28859 | 19 | |
23197 | 95639 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 252 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489 | 2104635 | 37.7592936513862 | -122.420616372933 | (37.7592936513862, -122.420616372933) | 2 | 4 | 7 | 28859 | 19 | |
44596 | 95625 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3562 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767392 | 6005880 | 2105517 | 37.7616810754377 | -122.422785274783 | (37.7616810754377, -122.422785274783) | 8 | 4 | 5 | 28859 | 19 | |
57428 | 95614 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 35 Temescal Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52561 | 5997427.8 | 2111420 | 37.7774086833784 | -122.45244386493 | (37.7774086833784, -122.45244386493) | 15 | 6 | 2 | 54 | 16 | |
97560 | 9555 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1195X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | |||
188714 | 9553 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1195X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | |||
184416 | 9550 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | |||
76635 | 95398 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1436 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767272 | 6003848 | 2099901 | 37.7461460032944 | -122.429412637248 | (37.7461460032944, -122.429412637248) | 2 | 7 | 5 | 63 | 22 | |
21703 | 95365 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647797 | -122.407799105269 | (37.797637647797, -122.407799105269) | 3 | 1 | 10 | 308 | 4 | ||
60118 | 95364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.479 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | 3 | 1 | 10 | 308 | 4 | ||
102196 | 95304 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | ||
29084 | 95303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | ||
46792 | 95302 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | ||
136183 | 95301 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
156468 | 95159 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2721 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||
53301 | 94914 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3600 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902 | 2106490 | 37.7641842232844 | -122.433154488347 | (37.7641842232844, -122.433154488347) | 15 | 4 | 5 | 28862 | 3 | ||
78444 | 94879 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 83 Ledyard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767655 | 6011819 | 2094865 | 37.7327662839989 | -122.401495893184 | (37.7327662839989, -122.401495893184) | 10 | 3 | 8 | 58 | 1 |
166845 | 94791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.7909810111097 | -122.450877583428 | (37.7909810111097, -122.450877583428) | 13 | 6 | 1 | 54 | 31 | ||
96066 | 94681 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 284 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53817 | 6001324 | 2096497 | 37.7366561951725 | -122.437896519679 | (37.7366561951725, -122.437896519679) | 2 | 7 | 5 | 63 | 7 | |
183795 | 94653 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 486 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53792 | 6003723 | 2095910 | 37.7351805553154 | -122.429560291545 | (37.7351805553154, -122.429560291545) | 2 | 7 | 5 | 63 | 7 | |
154724 | 94278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | 15 | 5 | 11 | 29490 | 41 | ||||
89727 | 94275 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 850 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6001000.8133 | 2111684.213 | 37.77833820266 | -122.440102619662 | (37.77833820266, -122.440102619662) | 15 | 5 | 11 | 29490 | 41 | ||||
140115 | 94205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 225 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 3 | 4 diameter | Permit Number 53606 | 6012323.95366 | 2116081.4267 | 37.7910500439823 | -122.401240507665 | (37.7910500439823, -122.401240507665) | 4 | 1 | 10 | 28854 | 6 | |
31005 | 94179 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 603 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53587 | 6010992.28107 | 2105475.07827 | 37.7618530869812 | -122.405100914986 | (37.7618530869812, -122.405100914986) | 10 | 3 | 8 | 28856 | 29 | |
156006 | 94037 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3664 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2010 12:00:00 AM | 3x3 | Permit Number 53447 | 6003979 | 2103071 | 37.7548574984992 | -122.429185650078 | (37.7548574984992, -122.429185650078) | 2 | 4 | 5 | 28862 | 22 | ||
22986 | 93972 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3425X 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | 3 | 3x6 | Permit Number 53400 | 6006959.7 | 2100858.4 | 37.7489504900318 | -122.418720633691 | (37.7489504900318, -122.418720633691) | 2 | 4 | 7 | 28859 | 19 | |
142739 | 93971 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3425X 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | 3 | 3x6 | Permit Number 53400 | 6006959.7 | 2100858.4 | 37.7489504900318 | -122.418720633691 | (37.7489504900318, -122.418720633691) | 2 | 4 | 7 | 28859 | 19 | |
145649 | 93831 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
192585 | 93830 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
115469 | 93829 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
68591 | 93828 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
103416 | 93827 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
112271 | 93826 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
34547 | 93825 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
193929 | 93824 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
183359 | 93823 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
72781 | 93822 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
23362 | 93821 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
65262 | 93820 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
63861 | 93819 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
52287 | 93818 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
80050 | 93817 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
131983 | 93816 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
125017 | 93815 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
155639 | 93814 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
163928 | 93813 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
35420 | 93812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
131011 | 93182 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53192 | 6003520 | 2105614 | 37.7618139755856 | -122.430954481065 | (37.7618139755856, -122.430954481065) | 15 | 4 | 5 | 28862 | 3 | ||
149168 | 93044 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 155 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5987698.59819 | 2114939.90173 | 37.7865111255347 | -122.486358421479 | (37.7865111255347, -122.486358421479) | 11 | 6 | 1 | 55 | 33 | ||||
184637 | 92268 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767 | 2098334 | 37.7412098217915 | -122.467615061471 | (37.7412098217915, -122.467615061471) | 1 | 8 | 4 | 59 | 40 | ||
66911 | 92267 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767 | 2098334 | 37.7412098217915 | -122.467615061471 | (37.7412098217915, -122.467615061471) | 1 | 8 | 4 | 59 | 40 | ||
65118 | 91691 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301-307 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.961989 | 2107907.789584 | 37.7683308170236 | -122.417725462175 | (37.7683308170236, -122.417725462175) | 8 | 4 | 7 | 28853 | 19 |
183528 | 91610 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | 2 | 4 | 7 | 28859 | 19 | |||
146253 | 91043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50399 | 6006460.43386 | 2121423.80416 | 37.8053899957025 | -122.421907764657 | (37.8053899957025, -122.421907764657) | 5 | 1 | 1 | 28858 | 32 | |
91874 | 91042 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006462.58838 | 2121409.81945 | 37.8053517187772 | -122.421899314626 | (37.8053517187772, -122.421899314626) | 5 | 1 | 1 | 28858 | 32 | |
142312 | 91041 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.74623 | 2121395.99646 | 37.8053138860806 | -122.421890864574 | (37.8053138860806, -122.421890864574) | 5 | 1 | 1 | 28858 | 32 | |
44763 | 90488 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 6 | 3x3 | 5987997.51268 | 2115126.89685 | 37.7870419790043 | -122.485337990995 | (37.7870419790043, -122.485337990995) | 11 | 6 | 1 | 55 | 33 | ||
44864 | 90394 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 314 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 6008277.004378 | 2108757.643904 | 37.770714082787 | -122.41472432574 | (37.770714082787, -122.41472432574) | 8 | 2 | 9 | 28853 | 19 | ||
8128 | 90393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
140812 | 90392 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
128309 | 90391 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 74 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007027.339502 | 2109746.308859 | 37.7733584293936 | -122.419117085527 | (37.7733584293936, -122.419117085527) | 8 | 2 | 9 | 28853 | 19 | ||
133422 | 90390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 68 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006999.109217 | 2109777.167755 | 37.7734415707499 | -122.419216927652 | (37.7734415707499, -122.419216927652) | 8 | 2 | 9 | 28853 | 19 | ||
189284 | 90389 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 68 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006999.109217 | 2109777.167755 | 37.7734415707499 | -122.419216927652 | (37.7734415707499, -122.419216927652) | 8 | 2 | 9 | 28853 | 19 | ||
67048 | 90388 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
141214 | 90387 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2014 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 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) );