trees
1,194 rows where qSpecies_id = 50 sorted by DBH
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
94618 | 84806 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53985 | 6002776 | 2103844 | 37.7569117968289 | -122.433401190257 | (37.7569117968289, -122.433401190257) | 2 | 4 | 5 | 28862 | 3 | |
95097 | 37750 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 40097 | 6009582.81268414 | 2100967.48036218 | 37.7493973403348 | -122.409657560346 | (37.7493973403348, -122.409657560346) | 2 | 4 | 7 | 28859 | 19 | ||
95421 | 37736 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
95611 | 46553 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | ||
96561 | 51473 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47785 | 6008227.06002157 | 2096462.73555684 | 37.7369522423723 | -122.414027160396 | (37.7369522423723, -122.414027160396) | 2 | 7 | 7 | 28859 | 2 | ||
97397 | 36056 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
98393 | 34741 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
99195 | 37745 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
99407 | 34313 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
99483 | 34194 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | Permit Number 38013 | 6005507.05529052 | 2099654.01670417 | 37.7455616340181 | -122.423658270556 | (37.7455616340181, -122.423658270556) | 2 | 7 | 5 | 28859 | 22 | |||
100567 | 34321 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
101368 | 40260 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41418 | 6006042.36187531 | 2101970.77964266 | 37.7519531379729 | -122.421971806823 | (37.7519531379729, -122.421971806823) | 2 | 4 | 5 | 28859 | 19 | ||
101742 | 34743 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
102805 | 36607 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1456 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39459 | 6009541.64009762 | 2100769.96881138 | 37.748852710074 | -122.409785996816 | (37.748852710074, -122.409785996816) | 2 | 4 | 7 | 28859 | 19 | |||
103487 | 80120 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1368 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53583 | 6010852.51966051 | 2101957.65368141 | 37.7521872076664 | -122.405336581456 | (37.7521872076664, -122.405336581456) | 10 | 4 | 8 | 28859 | 19 | ||
104984 | 121733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
105247 | 40466 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41551 | 6007432.5015154 | 2097996.59571862 | 37.7411192248043 | -122.416882950838 | (37.7411192248043, -122.416882950838) | 2 | 7 | 7 | 28859 | 2 | ||
106028 | 82561 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010041.95956984 | 2101582.34952093 | 37.7511113537145 | -122.408113170097 | (37.7511113537145, -122.408113170097) | 2 | 4 | 7 | 28859 | 19 | ||
106675 | 33028 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
106987 | 37008 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39622 | 6009161.44708429 | 2102917.71033779 | 37.7547286146948 | -122.411252407188 | (37.7547286146948, -122.411252407188) | 2 | 4 | 7 | 28859 | 19 | ||
107938 | 34311 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
108237 | 35794 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 230 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39044 | 6006467.16362039 | 2104758.98191383 | 37.7596328461688 | -122.42070069541 | (37.7596328461688, -122.42070069541) | 2 | 4 | 7 | 28859 | 19 | ||
108705 | 36911 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39557 | 6001782.24940233 | 2103410.78892741 | 37.7556658745596 | -122.436806934863 | (37.7556658745596, -122.436806934863) | 2 | 4 | 5 | 28862 | 22 | ||
108707 | 52220 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
109286 | 37272 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39812 | 6004581.43700171 | 2103112.60503565 | 37.7550058216408 | -122.427105217543 | (37.7550058216408, -122.427105217543) | 2 | 4 | 5 | 28862 | 22 | ||
109584 | 36605 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39458 | 6009592.15904366 | 2100798.22430039 | 37.7489331243871 | -122.409613295625 | (37.7489331243871, -122.409613295625) | 2 | 4 | 7 | 28859 | 19 | ||
109741 | 39737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
110649 | 64206 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | Permit No. 49278 | 6001454.61421942 | 2102939.02028788 | 37.7543518855401 | -122.437906209203 | (37.7543518855401, -122.437906209203) | 2 | 4 | 5 | 28862 | 22 | |||
110872 | 88303 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
110878 | 34326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
110905 | 121743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
111132 | 37445 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | 10 | 7 | 7 | 28859 | 2 | ||
111213 | 34335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
111735 | 37446 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | 10 | 7 | 7 | 28859 | 2 | |||
112129 | 50512 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2170 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47148 | 6008097.65074175 | 2105795.48714346 | 37.7625706116889 | -122.415135006616 | (37.7625706116889, -122.415135006616) | 8 | 4 | 7 | 28859 | 19 | ||
112615 | 52218 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
113449 | 37029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39639 | 6003842.3126639 | 2099561.92709037 | 37.7452146656232 | -122.429408127516 | (37.7452146656232, -122.429408127516) | 2 | 7 | 5 | 63 | 22 | ||
113687 | 52118 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 700 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.7763178722928 | -122.427977208208 | (37.7763178722928, -122.427977208208) | 7 | 9 | 11 | 28852 | 10 | ||
114545 | 36053 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
115595 | 39103 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3044 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40791 | 6008669.18392722 | 2102170.48666916 | 37.7526492866943 | -122.412901966068 | (37.7526492866943, -122.412901966068) | 2 | 4 | 7 | 28859 | 19 | |||
116126 | 121744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 7 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
116173 | 37022 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
117144 | 52221 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
117197 | 34779 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
117639 | 114960 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770791 | 6001920.2 | 2100491.9 | 37.7476591410723 | -122.436120992025 | (37.7476591410723, -122.436120992025) | 2 | 4 | 5 | 63 | 22 | |||
117701 | 34729 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | 2 | 4 | 7 | 28859 | 19 | ||
118063 | 68774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32703 | 6003671.21705714 | 2105010.40354042 | 37.7601652112687 | -122.430388414345 | (37.7601652112687, -122.430388414345) | 2 | 4 | 5 | 28862 | 3 | ||
119841 | 34060 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 3x3 | Permit Number 37962 | 6009449.36433284 | 2106657.97750104 | 37.7650146832031 | -122.410520807301 | (37.7650146832031, -122.410520807301) | 8 | 4 | 7 | 28859 | 19 | |
120105 | 37443 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39917 | 6010005.91327801 | 2098599.86014619 | 37.742920074008 | -122.408027513819 | (37.742920074008, -122.408027513819) | 10 | 7 | 7 | 28859 | 2 | ||
120584 | 36057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
121096 | 36598 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1334 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 39451 | 6009507.07319393 | 2101395.95284749 | 37.7505695862007 | -122.40994971369 | (37.7505695862007, -122.40994971369) | 2 | 4 | 7 | 28859 | 19 | ||
121545 | 104351 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2013 12:00:00 AM | 3x3 | Permit Number 769484 | 6005428.9 | 2104316.5 | 37.7583593225521 | -122.424260064239 | (37.7583593225521, -122.424260064239) | 2 | 4 | 5 | 28859 | 19 | ||
122314 | 97023 | Property Tree 8 | Jacaranda mimosifolia :: Jacaranda 50 | 1443 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.7488938036461 | -122.410459018192 | (37.7488938036461, -122.410459018192) | 2 | 4 | 7 | 28859 | 19 | ||||
122506 | 36059 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
124078 | 36595 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
124303 | 36063 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
124479 | 37738 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
126025 | 88537 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
126418 | 36541 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39414 | 6008400.50795497 | 2097269.02278879 | 37.7391758711573 | -122.413484478256 | (37.7391758711573, -122.413484478256) | 2 | 7 | 7 | 28859 | 2 | ||
126449 | 34733 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
126744 | 94041 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | Permit Number 53451 | 6005890 | 2099632 | 37.7455227900977 | -122.422332540821 | (37.7455227900977, -122.422332540821) | 2 | 7 | 5 | 28859 | 22 | |||
126850 | 255548 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 241 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006720 | 2104706 | 37.7595016169819 | -122.41982249933 | (37.7595016169819, -122.41982249933) | 2 | 4 | 7 | 28859 | 19 | ||||
127792 | 33046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
127965 | 36578 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2833 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2002 12:00:00 AM | Permit Number 39440 | 6010288.37913672 | 2101036.1480817 | 37.7496253993391 | -122.407222522654 | (37.7496253993391, -122.407222522654) | 2 | 4 | 7 | 28859 | 19 | ||
128376 | 46610 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 90 Stoneybrook Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44733 | 6005754.19470514 | 2093788.76212956 | 37.7294709047894 | -122.422387032926 | (37.7294709047894, -122.422387032926) | 9 | 7 | 6 | 28861 | 5 | |||
129239 | 36603 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39456 | 6009539.30350757 | 2100812.2828298 | 37.7489687640594 | -122.409797063203 | (37.7489687640594, -122.409797063203) | 2 | 4 | 7 | 28859 | 19 | ||
130082 | 95630 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767398 | 6004828 | 2102496 | 37.753326708053 | -122.426208635682 | (37.753326708053, -122.426208635682) | 2 | 4 | 5 | 28862 | 22 | |
130325 | 35308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3524 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38776 | 6006060.26352617 | 2105533.64133784 | 37.761736937829 | -122.422162997439 | (37.761736937829, -122.422162997439) | 8 | 4 | 5 | 28859 | 19 | ||
130336 | 39735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
130550 | 34378 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38129 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | 2 | 7 | 5 | 63 | 7 | ||
130697 | 37733 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
132012 | 37661 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
132383 | 42046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45105 | 6005486.77037609 | 2099946.40187796 | 37.7463633118872 | -122.423749198438 | (37.7463633118872, -122.423749198438) | 2 | 7 | 5 | 28859 | 22 | ||
133027 | 39199 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1213 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40850 | 6010063.59711896 | 2102133.62856163 | 37.7526262552662 | -122.408077219023 | (37.7526262552662, -122.408077219023) | 2 | 4 | 7 | 28859 | 19 | |||
133172 | 37028 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39638 | 6004336.0974524 | 2099589.08608997 | 37.7453171819754 | -122.427702638011 | (37.7453171819754, -122.427702638011) | 2 | 7 | 5 | 63 | 22 | ||
134370 | 35545 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
134812 | 42592 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 974 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2001 12:00:00 AM | Permit Number 42665 | 6009932.75878018 | 2103534.24461305 | 37.7564647077179 | -122.40862847969 | (37.7564647077179, -122.40862847969) | 2 | 4 | 7 | 28859 | 19 | ||
135649 | 37744 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
136523 | 37732 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
136750 | 59221 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2009 12:00:00 AM | 3x3 | Permit Number 52989 | 6004451.77295889 | 2107409.78146369 | 37.7667975133385 | -122.427859811231 | (37.7667975133385, -122.427859811231) | 8 | 4 | 5 | 28862 | 3 | |
137130 | 38274 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 645 Texas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.7576604143577 | -122.394153206319 | (37.7576604143577, -122.394153206319) | 10 | 3 | 8 | 28856 | 29 | |||
137953 | 34734 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38384 | 6008507.54779719 | 2101522.76910569 | 37.7508617255783 | -122.413415130751 | (37.7508617255783, -122.413415130751) | 2 | 4 | 7 | 28859 | 19 | ||
138150 | 121741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
138435 | 39077 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2280X Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
138812 | 121727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
139065 | 34317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
139101 | 36602 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1440 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 43812 | 6009537.9015539 | 2100837.67123452 | 37.7490383964317 | -122.40980370305 | (37.7490383964317, -122.40980370305) | 2 | 4 | 7 | 28859 | 19 | ||
141115 | 34778 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
142531 | 43929 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1097x York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 43519 | 6010038 | 2102851 | 37.7545945643559 | -122.408216329842 | (37.7545945643559, -122.408216329842) | 2 | 4 | 7 | 28859 | 19 | ||
142727 | 121739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
142907 | 34337 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
143048 | 36511 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50549 | 6007227.68347498 | 2097723.04326722 | 37.7403565876102 | -122.417571756215 | (37.7403565876102, -122.417571756215) | 2 | 7 | 7 | 28859 | 2 | ||
143831 | 36060 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
144457 | 37759 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.7512141902983 | -122.40794259966 | (37.7512141902983, -122.40794259966) | 2 | 4 | 7 | 28859 | 19 | ||
145234 | 33027 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
145866 | 91415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 46 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2009 12:00:00 AM | 3x3 | Permit Number 52098 | 6003215 | 2107427 | 37.7667747483278 | -122.432138830712 | (37.7667747483278, -122.432138830712) | 15 | 5 | 5 | 28862 | 3 | ||
145930 | 44005 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
146209 | 74729 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 3174-3190 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1996 12:00:00 AM | 6008516.4229759 | 2101575.33994414 | 37.7510065716159 | -122.413388156863 | (37.7510065716159, -122.413388156863) | 2 | 4 | 7 | 28859 | 19 | ||||
146261 | 34732 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
146505 | 68109 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31855 | 6008266.5705023 | 2099517.92121492 | 37.7453433283283 | -122.414106634567 | (37.7453433283283, -122.414106634567) | 2 | 7 | 7 | 28859 | 2 |
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) );