trees
1,985 rows where qSpecies_id = 83 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
449 | 252970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2019 12:00:00 AM | 3 | |||||||||||||
2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3450 | 52146 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2005 12:00:00 AM | Permit Number 48337 | |||||||||||||
3492 | 30592 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
7715 | 260428 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 745 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
9907 | 30593 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
13512 | 259080 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
15478 | 252965 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:04:00 PM | 3 | |||||||||||||
15527 | 19972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
83858 | 179336 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.7099652661681 | -122.43263957156 | (37.7099652661681, -122.43263957156) | 9 | 7 | 6 | 28861 | 5 | |||
109384 | 69409 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.7100840871049 | -122.436495934551 | (37.7100840871049, -122.436495934551) | 9 | 7 | 6 | 28861 | 5 | ||
95671 | 179330 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 21 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001459.59412 | 2086865.71976 | 37.7102185880902 | -122.43673848452 | (37.7102185880902, -122.43673848452) | 9 | 7 | 6 | 28861 | 5 | |||
147801 | 179331 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 21 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001453.95042 | 2086881.4918 | 37.7102615738952 | -122.436759118535 | (37.7102615738952, -122.436759118535) | 9 | 7 | 6 | 28861 | 5 | |||
137813 | 179332 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 21 Drake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001443.39306 | 2086909.85061 | 37.7103388409345 | -122.436797635603 | (37.7103388409345, -122.436797635603) | 9 | 7 | 6 | 28861 | 5 | |||
38096 | 179333 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 21 Drake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001438.26403 | 2086921.6489 | 37.7103709449371 | -122.436816206603 | (37.7103709449371, -122.436816206603) | 9 | 7 | 6 | 28861 | 5 | |||
129981 | 69396 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.28453 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | 9 | 7 | 6 | 28861 | 5 | |
185252 | 1848 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2401 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011043.02806 | 2086938.15421 | 37.7109574665846 | -122.403621108454 | (37.7109574665846, -122.403621108454) | 10 | 3 | 8 | 309 | 1 | |||
31543 | 159341 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.29778 | 2087238.08175 | 37.7110558677139 | -122.447991998028 | (37.7110558677139, -122.447991998028) | 9 | 7 | 6 | 28861 | 25 | ||
5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
155154 | 258328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
100235 | 252967 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | 9 | 7 | 6 | 28861 | 25 | |||
144444 | 159295 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.11999 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | 9 | 7 | 6 | 28861 | 25 | ||
110348 | 252966 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | 9 | 7 | 6 | 28861 | 25 | |||
88905 | 258327 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998030 | 2087350 | 37.7113528047065 | -122.448626659544 | (37.7113528047065, -122.448626659544) | 9 | 7 | 6 | 28861 | 25 | ||||
140726 | 159297 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.33924 | 2087362.06343 | 37.7113897212371 | -122.448398243388 | (37.7113897212371, -122.448398243388) | 9 | 7 | 6 | 28861 | 25 | ||
91148 | 258326 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997997 | 2087369 | 37.7114030873569 | -122.448742083083 | (37.7114030873569, -122.448742083083) | 9 | 7 | 6 | 28861 | 25 | ||||
157186 | 159298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.50474 | 37.7114070835507 | -122.448418296488 | (37.7114070835507, -122.448418296488) | 9 | 7 | 6 | 28861 | 25 | ||
38701 | 258325 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997933 | 2087452 | 37.7116273264288 | -122.448969257639 | (37.7116273264288, -122.448969257639) | 9 | 7 | 6 | 28861 | 25 | ||||
11654 | 259082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1023 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009473.49904 | 2087244.25049 | 37.7117101453965 | -122.409067379874 | (37.7117101453965, -122.409067379874) | 9 | 7 | 8 | 309 | 39 | |||
19372 | 259083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1029 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009458.60985 | 2087249.80978 | 37.7117245759679 | -122.409119233208 | (37.7117245759679, -122.409119233208) | 9 | 7 | 8 | 309 | 39 | |||
11829 | 259084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1041 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009428.83146 | 2087260.92835 | 37.7117534370142 | -122.409222939968 | (37.7117534370142, -122.409222939968) | 9 | 7 | 8 | 309 | 39 | |||
4805 | 74096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001902.78384 | 2087667.72771 | 37.7124459030227 | -122.435264062185 | (37.7124459030227, -122.435264062185) | 9 | 7 | 6 | 28861 | 5 | |||
46622 | 159220 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.7124711910608 | -122.446492798529 | (37.7124711910608, -122.446492798529) | 9 | 7 | 6 | 28861 | 25 | |||
30981 | 69392 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.7124713889678 | -122.435199299374 | (37.7124713889678, -122.435199299374) | 9 | 7 | 6 | 28861 | 5 | ||
79546 | 179334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.435111061438 | (37.7125700310481, -122.435111061438) | 9 | 7 | 6 | 28861 | 5 | |||
155889 | 69400 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1155 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33504 | 6001338.55016435 | 2087735.88894959 | 37.7126010005012 | -122.437219100024 | (37.7126010005012, -122.437219100024) | 9 | 7 | 6 | 28861 | 5 | ||
122452 | 179335 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | 9 | 7 | 6 | 28861 | 5 | |||
19630 | 69390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | 9 | 7 | 6 | 28861 | 5 | ||
164571 | 69412 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 411 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33517 | 6002045.14092784 | 2087792.75766672 | 37.7127972910065 | -122.434780968582 | (37.7127972910065, -122.434780968582) | 9 | 7 | 6 | 28861 | 5 | ||
121909 | 159213 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 300 Ellington Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998902.8056 | 2087977.93006 | 37.7131268274265 | -122.445655159179 | (37.7131268274265, -122.445655159179) | 9 | 7 | 6 | 28861 | 25 | |||
190752 | 159145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 291 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:23:00 AM | 3 | Width 0ft | 5999009.28945 | 2088027.75173 | 37.7132697053972 | -122.445290696322 | (37.7132697053972, -122.445290696322) | 9 | 7 | 6 | 28861 | 25 | ||
59889 | 213985 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 431 Capitol Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995022.34889 | 2088455.31671 | 37.714215306566 | -122.459101782823 | (37.714215306566, -122.459101782823) | 9 | 8 | 6 | 28861 | 24 | |||
68931 | 39937 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 327 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50713 | 6009355.37071 | 2088298.86848 | 37.7145992918994 | -122.409550050915 | (37.7145992918994, -122.409550050915) | 9 | 7 | 8 | 309 | 39 | |
108446 | 213982 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Lobos St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994935.45629 | 2088691.95467 | 37.714860062915 | -122.459419242599 | (37.714860062915, -122.459419242599) | 9 | 8 | 6 | 28861 | 24 | |||
142610 | 213983 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Lobos St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994955.32932 | 2088691.95089 | 37.7148611951615 | -122.459350553292 | (37.7148611951615, -122.459350553292) | 9 | 8 | 6 | 28861 | 24 | |||
103163 | 213984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Lobos St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994978.50476 | 2088691.46562 | 37.7148611951759 | -122.459270414704 | (37.7148611951759, -122.459270414704) | 9 | 8 | 6 | 28861 | 24 | |||
51808 | 111862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
60043 | 111861 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
132862 | 111863 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
15242 | 49368 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.404927851118 | (37.7149060701976, -122.404927851118) | 9 | 7 | 8 | 309 | 39 | |||
66270 | 39955 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 273 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 9 | Permit Number 41217 | 6009804.77414 | 2088411.37216 | 37.7149333756547 | -122.408004652316 | (37.7149333756547, -122.408004652316) | 9 | 7 | 8 | 309 | 39 | |
93807 | 31159 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | 9 | 8 | 6 | 64 | 24 | ||
104056 | 213987 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 6 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5996535.27353 | 2089022.9105 | 37.7158606459376 | -122.453913522906 | (37.7158606459376, -122.453913522906) | 9 | 8 | 6 | 28861 | 24 | |||
162285 | 213986 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5996577.00096 | 2089023.1695 | 37.7158637494767 | -122.453769313014 | (37.7158637494767, -122.453769313014) | 9 | 8 | 6 | 28861 | 24 | |||
84593 | 35042 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 158 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/1998 12:00:00 AM | Permit Number 38609 | 5996885.33354798 | 2089115.06440217 | 37.7161337438742 | -122.452710206461 | (37.7161337438742, -122.452710206461) | 9 | 8 | 6 | 28861 | 24 | ||
53874 | 197142 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012879.12382 | 2089210.84364 | 37.7173002150142 | -122.397434365426 | (37.7173002150142, -122.397434365426) | 10 | 3 | 8 | 58 | 1 | |||
148281 | 82705 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52460 | 6012945.60921507 | 2089212.94135713 | 37.7173096765194 | -122.397204701992 | (37.7173096765194, -122.397204701992) | 10 | 3 | 8 | 58 | 1 | ||
28724 | 197143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012876.39378 | 2089220.96781 | 37.7173278619583 | -122.397444511578 | (37.7173278619583, -122.397444511578) | 10 | 3 | 8 | 58 | 1 | |||
670 | 197144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.7173688854414 | -122.397447893917 | (37.7173688854414, -122.397447893917) | 10 | 3 | 8 | 58 | 1 | |||
10024 | 35136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | 9 | 7 | 6 | 28861 | 5 | |
87242 | 85246 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 121 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49547 | 6001091.3 | 2089693.7 | 37.7179626543102 | -122.438213837389 | (37.7179626543102, -122.438213837389) | 9 | 7 | 6 | 28861 | 5 | |||
87443 | 88469 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 921 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51423 | 6014544.1 | 2089500.7 | 37.7181886666833 | -122.391699531232 | (37.7181886666833, -122.391699531232) | 10 | 3 | 8 | 58 | 1 | |||
100411 | 200236 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.7182551721999 | -122.391677176393 | (37.7182551721999, -122.391677176393) | 10 | 3 | 8 | 58 | 1 | |||
7723 | 69741 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010157.17597 | 2089735.57492 | 37.7185890892048 | -122.406879871126 | (37.7185890892048, -122.406879871126) | 10 | 7 | 8 | 309 | 39 | |||
193279 | 179285 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010162.36149 | 2089750.07728 | 37.7186291998585 | -122.406862968371 | (37.7186291998585, -122.406862968371) | 10 | 7 | 8 | 309 | 39 | |||
109425 | 213946 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996526.79114 | 2090102.31062 | 37.7188239399468 | -122.454020752656 | (37.7188239399468, -122.454020752656) | 9 | 8 | 6 | 28861 | 24 | |||
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
148798 | 213978 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 250 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994758.88079 | 2090253.13715 | 37.7191365451831 | -122.460142594324 | (37.7191365451831, -122.460142594324) | 9 | 8 | 6 | 28861 | 24 | |||
91043 | 213979 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 254 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994759.40129 | 2090277.98422 | 37.7192047992523 | -122.46014259432 | (37.7192047992523, -122.46014259432) | 9 | 8 | 6 | 28861 | 24 | |||
98005 | 213980 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | 9 | 8 | 6 | 28861 | 24 | |||
116054 | 213977 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994717.86147 | 2090376.18551 | 37.7194720471732 | -122.460293291905 | (37.7194720471732, -122.460293291905) | 9 | 8 | 6 | 28861 | 24 | |||
13556 | 264663 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1078 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014476.86082 | 2089998.27904 | 37.7195511879651 | -122.391966726039 | (37.7195511879651, -122.391966726039) | 10 | 3 | 8 | 58 | 1 | |||
141906 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
152541 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
149159 | 86713 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 938 Garfield St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527 | 2090568.7 | 37.7198165808065 | -122.471336842251 | (37.7198165808065, -122.471336842251) | 9 | 8 | 6 | 64 | 24 | ||||
157903 | 179283 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 126 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004517.28509 | 2090394.86473 | 37.7200821580385 | -122.426421596896 | (37.7200821580385, -122.426421596896) | 9 | 7 | 6 | 28861 | 5 | |||
61565 | 213950 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995061.44128 | 2090626.04133 | 37.7201778494978 | -122.459123753274 | (37.7201778494978, -122.459123753274) | 9 | 8 | 6 | 28861 | 24 | |||
39382 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
78664 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
68952 | 213951 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994724.048 | 2090709.90077 | 37.7203887054465 | -122.460296073498 | (37.7203887054465, -122.460296073498) | 9 | 8 | 6 | 28861 | 24 | |||
3341 | 71320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004289.26563 | 2090538.00218 | 37.7204622897839 | -122.427219973626 | (37.7204622897839, -122.427219973626) | 9 | 7 | 6 | 28861 | 5 | |||
120812 | 213952 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994769.73406 | 2090948.84155 | 37.7210474075953 | -122.460155454611 | (37.7210474075953, -122.460155454611) | 9 | 8 | 6 | 28861 | 24 | |||
32765 | 213953 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994770.43192 | 2090973.10157 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | 9 | 8 | 6 | 28861 | 24 | |||
76177 | 213976 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995023.46765 | 2090970.59824 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | 9 | 8 | 6 | 28861 | 24 | |||
14804 | 264658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 04:59:00 PM | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.391072554716 | (37.7211221378179, -122.391072554716) | 10 | 3 | 8 | 58 | 1 | |||
173209 | 213954 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.7212043905451 | -122.460151465241 | (37.7212043905451, -122.460151465241) | 9 | 8 | 6 | 28861 | 24 | |||
124638 | 213975 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995024.51997 | 2091003.24873 | 37.7212114484221 | -122.459278678595 | (37.7212114484221, -122.459278678595) | 9 | 8 | 6 | 28861 | 24 | |||
133184 | 213974 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | 9 | 8 | 6 | 28861 | 24 | |||
131634 | 36824 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1220 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49072 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
20112 | 213955 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | 9 | 8 | 6 | 28861 | 24 | |||
1920 | 213973 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995027.24606 | 2091045.40909 | 37.7213273674346 | -122.459272306869 | (37.7213273674346, -122.459272306869) | 9 | 8 | 6 | 28861 | 24 | |||
82089 | 36825 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.7213417726319 | -122.391773212862 | (37.7213417726319, -122.391773212862) | 10 | 3 | 8 | 58 | 1 | |
154288 | 213956 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994772.08022 | 2091060.83948 | 37.7213550620588 | -122.460155454607 | (37.7213550620588, -122.460155454607) | 9 | 8 | 6 | 28861 | 24 | |||
145023 | 213972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.7214019581083 | -122.459265935174 | (37.7214019581083, -122.459265935174) | 9 | 8 | 6 | 28861 | 24 | |||
69735 | 213957 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994771.7805 | 2091087.85201 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | 9 | 8 | 6 | 28861 | 24 | |||
189124 | 213971 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995026.07265 | 2091112.61421 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | 9 | 8 | 6 | 28861 | 24 | |||
88487 | 213958 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.7215364993901 | -122.460152462564 | (37.7215364993901, -122.460152462564) | 9 | 8 | 6 | 28861 | 24 | |||
132540 | 87073 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 4 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 |
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) );