Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5874 | 5874 | 97590 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 559 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001615.3648 | 2110410.2466 | 37.774875178544995 | -122.437885389718 | (37.774875178545, -122.437885389718) | ||
| 5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
| 6000 | 6000 | 28097 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001567.17 | 2110752.9686 | 37.7758134664372 | -122.438076660597 | (37.7758134664372, -122.438076660597) | ||
| 6007 | 6007 | 28723 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003233.5773 | 2114519.7036 | 37.7862506062504 | -122.43258125527099 | (37.7862506062504, -122.432581255271) | |||
| 6030 | 6030 | 94373 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1633 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2013 12:00:00 AM | 3 | 4x4 | 6003081.472 | 2113940.278 | 37.7846510231483 | -122.43306608604901 | (37.7846510231483, -122.433066086049) | ||
| 6072 | 6072 | 24616 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001554.3804 | 2111297.3519 | 37.777307478654706 | -122.438159908991 | (37.7773074786547, -122.438159908991) | |
| 6089 | 6089 | 11017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007000.76456 | 2121055.6377 | 37.8044095620003 | -122.420011732067 | (37.8044095620003, -122.420011732067) | |||
| 6148 | 6148 | 24577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 5 | 3X3 | 6002897.54633 | 2115611.42006 | 37.7892291200774 | -122.433821893176 | (37.7892291200774, -122.433821893176) | ||
| 6239 | 6239 | 11016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.42000582623301 | (37.804348902732, -122.420005826233) | |||
| 6272 | 6272 | 41118 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1831 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 10 | 3x6 | Permit Number 41864 | 5998988.6196 | 2110750.7439 | 37.7756603770461 | -122.44699632592899 | (37.7756603770461, -122.446996325929) | |
| 6389 | 6389 | 65428 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 720 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1989 12:00:00 AM | 8 | 3x3 | Permit Number 28287 | 6010438.53437 | 2116215.60904 | 37.791313109171206 | -122.40777348606899 | (37.7913131091712, -122.407773486069) | |
| 6544 | 6544 | 8114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 24 | 3X3 | 6003807.6781 | 2111475.048 | 37.7779232822146 | -122.430377706699 | (37.7779232822146, -122.430377706699) | ||
| 6693 | 6693 | 7357 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002807.95732 | 2116239.44488 | 37.7909484313614 | -122.43417677466499 | (37.7909484313614, -122.434176774665) | |||
| 6760 | 6760 | 24628 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 536 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001694.2572 | 2110311.9357 | 37.774609727324204 | -122.437605442785 | (37.7746097273242, -122.437605442785) | |
| 7007 | 7007 | 66829 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 142 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 30126 | 5996834.5871 | 2112040.6558 | 37.7790788371058 | -122.45454081935101 | (37.7790788371058, -122.454540819351) | |
| 7081 | 7081 | 11436 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1998 12:00:00 AM | 3 | 3X3 | 6005581.912830001 | 2117259.85377 | 37.793907265665496 | -122.424651612384 | (37.7939072656655, -122.424651612384) | ||
| 7371 | 7371 | 44106 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1242 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778937 | 6007599.34177 | 2118533.61268 | 37.797518421388205 | -122.41776142416401 | (37.7975184213882, -122.417761424164) | |
| 7406 | 7406 | 97595 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x4 | 6001524.4178 | 2111055.242 | 37.7766410017417 | -122.438246210395 | (37.7766410017417, -122.438246210395) | ||
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 7792 | 7792 | 97581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001597.3606 | 2110988.4698 | 37.776461810461704 | -122.43798909643101 | (37.7764618104617, -122.437989096431) | ||
| 7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
| 8085 | 8085 | 5202 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X4 | 6001595.2588 | 2111007.3853 | 37.7765136281427 | -122.437997722367 | (37.7765136281427, -122.437997722367) | |
| 8237 | 8237 | 18921 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2657 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002082.518999999 | 2115701.12329 | 37.789429139198 | -122.43664820785101 | (37.789429139198, -122.436648207851) | ||
| 8276 | 8276 | 7371 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2430 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6002752.41216 | 2116639.2393 | 37.7920430115354 | -122.43439755460501 | (37.7920430115354, -122.434397554605) | ||
| 8303 | 8303 | 97591 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001649.1323 | 2110166.4258 | 37.7742076278049 | -122.43775111477899 | (37.7742076278049, -122.437751114779) | ||
| 8311 | 8311 | 5206 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 4X4 | 6001519.3329 | 2111090.328 | 37.7767370498578 | -122.438266314655 | (37.7767370498578, -122.438266314655) | |
| 8313 | 8313 | 110973 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2231 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002796.68152 | 2115999.3322 | 37.7902885034734 | -122.434198615596 | (37.7902885034734, -122.434198615596) | |||
| 8349 | 8349 | 30526 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 60 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1995 12:00:00 AM | 10 | 3x3 | 6008665.53874 | 2112580.6235700003 | 37.7812329033191 | -122.413650815535 | (37.7812329033191, -122.413650815535) | ||
| 8394 | 8394 | 97584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 818 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001564.5243 | 2111243.3358 | 37.777159740959895 | -122.43812094768101 | (37.7771597409599, -122.438120947681) | ||
| 8402 | 8402 | 43083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 220 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51045 | 6009044.65676 | 2113355.74904 | 37.783382494344 | -122.412394054366 | (37.783382494344, -122.412394054366) | |
| 8431 | 8431 | 97593 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001569.9782 | 2110730.4395 | 37.7757517668907 | -122.438065332169 | (37.7757517668907, -122.438065332169) | |||
| 8461 | 8461 | 28724 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1970 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003220.1851 | 2114518.78 | 37.7862473108086 | -122.432627522769 | (37.7862473108086, -122.432627522769) | |||
| 8466 | 8466 | 59594 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1447 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | 3x3 | Permit Number 18991 | 6000147.142999999 | 2113940.7254 | 37.7844853693895 | -122.44321788363199 | (37.7844853693895, -122.443217883632) | |
| 8586 | 8586 | 97596 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 783 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001525.9433 | 2111041.0042 | 37.7766019950898 | -122.438239913038 | (37.7766019950898, -122.438239913038) | ||||
| 8857 | 8857 | 24567 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2123 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6002841.2397 | 2115668.08623 | 37.789381515596396 | -122.434020759375 | (37.7893815155964, -122.434020759375) | ||
| 9118 | 9118 | 24139 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 120X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9356 | 9356 | 5932 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1355 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6004005.8425 | 2112845.6747 | 37.781697906038 | -122.429789972847 | (37.781697906038, -122.429789972847) | |||
| 9366 | 9366 | 24140 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 120X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 9425 | 9425 | 24116 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 180X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | 3 | 3X3 | 6016348.1117358 | 2095906.4833443002 | 37.735877662010296 | -122.38591004253 | (37.7358776620103, -122.38591004253) | ||
| 9538 | 9538 | 24790 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7600X Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | 5983417.22641 | 2112490.7888700003 | 37.7795361021078 | -122.500989471143 | (37.7795361021078, -122.500989471143) | |||
| 9622 | 9622 | 122597 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9623 | 9623 | 75842 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9625 | 9625 | 122599 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9627 | 9627 | 122596 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9628 | 9628 | 122598 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9630 | 9630 | 72480 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9633 | 9633 | 75872 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9745 | 9745 | 47282 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2810 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45227 | 6010345.86300325 | 2101091.40389861 | 37.7497803366023 | -122.407027634693 | (37.7497803366023, -122.407027634693) | |
| 9764 | 9764 | 122593 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9765 | 9765 | 122594 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 10268 | 10268 | 49966 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2003 12:00:00 AM | Permit Number 46718 | 6000426.47543442 | 2105220.01428839 | 37.7605564179186 | -122.44162544737301 | (37.7605564179186, -122.441625447373) | |||
| 11740 | 11740 | 108556 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) |
| 11899 | 11899 | 113090 | Section 143 8 | Pyrus calleryana :: Ornamental Pear 9 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.6087200001 | 37.7303322746045 | -122.41230559972999 | (37.7303322746045, -122.41230559973) | ||
| 13355 | 13355 | 22260 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4636 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1996 12:00:00 AM | 6 | 3x3 | 6015027.458 | 2095928.9019999998 | 37.7358660451645 | -122.390477668904 | (37.7358660451645, -122.390477668904) | ||
| 13363 | 13363 | 91696 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1699 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007461.4288800005 | 2108586.23099 | 37.770197566194504 | -122.41753327153799 | (37.7701975661945, -122.417533271538) | ||
| 13365 | 13365 | 22227 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 3 | 3x3 | 6015350.6152 | 2096709.0679 | 37.7380261434859 | -122.38941484248998 | (37.7380261434859, -122.38941484249) | ||
| 13370 | 13370 | 84837 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 13X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 2x3 | Permit No. 49303 | 6010462.24216 | 2111775.7288599997 | 37.779123579430106 | -122.407378318556 | (37.7791235794301, -122.407378318556) | |
| 13402 | 13402 | 98185 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009313.61515 | 2110882.15559 | 37.7766056827446 | -122.41128876238001 | (37.7766056827446, -122.41128876238) | |||
| 13434 | 13434 | 22229 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015364.7865 | 2096754.4159 | 37.73815144552721 | -122.38936901073099 | (37.7381514455272, -122.389369010731) | |||
| 13506 | 13506 | 22236 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015297.7091 | 2096577.2751 | 37.737661333943 | -122.389588564769 | (37.737661333943, -122.389588564769) | |||
| 13551 | 13551 | 22289 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4836 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1995 12:00:00 AM | 3 | 3X3 | 6014859.2794 | 2095367.428 | 37.734315020944 | -122.39101990239901 | (37.734315020944, -122.391019902399) | ||
| 13553 | 13553 | 22248 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015177.6578 | 2096215.1707 | 37.7366604118004 | -122.389978355542 | (37.7366604118004, -122.389978355542) | |||
| 13567 | 13567 | 105276 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015520.229280001 | 2112423.42174 | 37.7811837949483 | -122.38992578265699 | (37.7811837949483, -122.389925782657) | |
| 13619 | 13619 | 22307 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014686.8832 | 2094799.1002 | 37.7327449405845 | -122.391576215676 | (37.7327449405845, -122.391576215676) | ||||
| 13668 | 13668 | 24300 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 10 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016267.21973 | 2096044.36505 | 37.736251780486604 | -122.386199330252 | (37.7362517804866, -122.386199330252) | ||
| 13672 | 13672 | 22228 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4343 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015357.7009 | 2096730.7972 | 37.7380862005585 | -122.38939186050399 | (37.7380862005585, -122.389391860504) | |||
| 13695 | 13695 | 22311 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5048 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014675.8119 | 2094762.1958 | 37.7326429940585 | -122.391611912964 | (37.7326429940585, -122.391611912964) | |||
| 13850 | 13850 | 98187 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777050 | 6009249.68117 | 2110819.91866 | 37.7764312088743 | -122.41150553135598 | (37.7764312088743, -122.411505531356) | |
| 13871 | 13871 | 95055 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5100X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014636.9706 | 2094632.7306 | 37.7322853528356 | -122.39173714895 | (37.7322853528356, -122.39173714895) | |||
| 13897 | 13897 | 83463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.77931661531171 | -122.407540511299 | (37.7793166153117, -122.407540511299) | |
| 13950 | 13950 | 22303 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5012X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014706.917 | 2094874.4907 | 37.7329530595777 | -122.391512222074 | (37.7329530595777, -122.391512222074) | |||
| 14054 | 14054 | 95063 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4911 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014862.0973 | 2095159.3952 | 37.7337439615305 | -122.39099562481701 | (37.7337439615305, -122.390995624817) | |||
| 14060 | 14060 | 22317 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 5122 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/1992 12:00:00 AM | 3 | 3x3 | 6014608.749 | 2094535.9425 | 37.7320180256942 | -122.39182795294201 | (37.7320180256942, -122.391827952942) | ||
| 14105 | 14105 | 102389 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 90X Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.24129 | 2111421.87021 | 37.7781680812419 | -122.406357067338 | (37.7781680812419, -122.406357067338) | |||
| 14123 | 14123 | 22273 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4726 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014961.0301 | 2095699.0403 | 37.735231206510704 | -122.390691280263 | (37.7352312065107, -122.390691280263) | |||
| 14265 | 14265 | 22256 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4622 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1995 12:00:00 AM | 6 | 3x3 | 6015042.2198 | 2095979.5138 | 37.7360058337427 | -122.390430166333 | (37.7360058337427, -122.390430166333) | ||
| 14392 | 14392 | 22293 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4910 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014812.3581 | 2095203.9942 | 37.733863661185495 | -122.39117070574301 | (37.7338636611855, -122.391170705743) | |||
| 14394 | 14394 | 24301 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 14 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016327.55349 | 2096048.14928 | 37.7362655104391 | -122.385990993297 | (37.7362655104391, -122.385990993297) | |||
| 14396 | 14396 | 92868 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4800 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014891.438999999 | 2095469.7059 | 37.7345976397448 | -122.39091586114999 | (37.7345976397448, -122.39091586115) | |||
| 14543 | 14543 | 22318 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5122 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1995 12:00:00 AM | 3 | 3x3 | 6014602.7867 | 2094516.4656 | 37.73196421508489 | -122.39184720465799 | (37.7319642150849, -122.391847204658) | ||
| 14558 | 14558 | 22291 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/13/1999 12:00:00 AM | 3 | 3x3 | 6014819.739 | 2095230.8817 | 37.733937898392206 | -122.391147066285 | (37.7339378983922, -122.391147066285) | ||
| 14591 | 14591 | 22321 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5135 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014664.7848 | 2094477.5071 | 37.7318606845446 | -122.39163013942499 | (37.7318606845446, -122.391630139425) | |||
| 14658 | 14658 | 10994 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2013 12:00:00 AM | 3 | 3X3 | 6016116.07134 | 2097158.9292099997 | 37.7393037809554 | -122.38679962052099 | (37.7393037809554, -122.386799620521) | ||
| 14709 | 14709 | 22250 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015190.8442 | 2096262.8930000002 | 37.736792178811996 | -122.389936096639 | (37.736792178812, -122.389936096639) | |||
| 14719 | 14719 | 98186 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009297.66811 | 2110865.56699 | 37.7765592399587 | -122.411342755875 | (37.7765592399587, -122.411342755875) | |||
| 14725 | 14725 | 22226 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4342 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1999 12:00:00 AM | 12 | 3X3 | 6015299.3625 | 2096815.5886 | 37.7383157858175 | -122.389599487386 | (37.7383157858175, -122.389599487386) | ||
| 14827 | 14827 | 22296 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4920 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014793.9059 | 2095156.0185 | 37.7337309056506 | -122.391231148662 | (37.7337309056506, -122.391231148662) | |||
| 14874 | 14874 | 22298 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014820.3268 | 2095023.3662 | 37.73336813561429 | -122.391130534135 | (37.7333681356143, -122.391130534135) | |||
| 14891 | 14891 | 22225 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4342 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 12 | 3x3 | 6015302.1967 | 2096838.735 | 37.7383794982525 | -122.389591304141 | (37.7383794982525, -122.389591304141) | ||
| 14900 | 14900 | 42231 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42486 | 6010159.8373 | 2112236.08642 | 37.780370682809 | -122.408456946549 | (37.780370682809, -122.408456946549) | |
| 14958 | 14958 | 95062 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4947 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014835.7159 | 2095070.6328 | 37.7334987740836 | -122.39108063188101 | (37.7334987740836, -122.391080631881) | |||
| 14965 | 14965 | 95845 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 148 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010292.7909 | 2112199.1337200003 | 37.780276664085704 | -122.40799438924999 | (37.7802766640857, -122.40799438925) | |||
| 15001 | 15001 | 105275 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | |
| 15079 | 15079 | 42230 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 1 | 5x3 | Permit Number 42486 | 6010185.283980001 | 2112260.71785 | 37.7804397399325 | -122.408370652088 | (37.7804397399325, -122.408370652088) |
| 15092 | 15092 | 22219 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4301 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 6 | 3x3 | 6015377.5406 | 2096805.4325 | 37.7382922337956 | -122.389328474573 | (37.7382922337956, -122.389328474573) | ||
| 15118 | 15118 | 22247 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6015208.4261 | 2096311.2431 | 37.7369259133775 | -122.3898786841 | (37.7369259133775, -122.3898786841) | |||
| 15130 | 15130 | 22319 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5131 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014671.3256 | 2094492.551 | 37.731902355110996 | -122.391608577745 | (37.731902355111, -122.391608577745) | |||
| 15140 | 15140 | 95292 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4508 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015152.932999999 | 2096346.9761 | 37.7370209512786 | -122.39007304552901 | (37.7370209512786, -122.390073045529) | |||
| 15201 | 15201 | 22305 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5024 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014702.6993 | 2094852.8752 | 37.7328934737014 | -122.39152529321899 | (37.7328934737014, -122.391525293219) | |||
| 15221 | 15221 | 22244 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4445 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015258.502 | 2096439.8138 | 37.737281719223496 | -122.38971452537201 | (37.7372817192235, -122.389714525372) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");