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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 38869 | 38869 | 47100 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 229 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 4 | Permit Number 45081 | 5996640.441000001 | 2111213.02603 | 37.7767952462698 | -122.455152622085 | (37.7767952462698, -122.455152622085) | |
| 39072 | 39072 | 58938 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1354 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 4 | Permit Number 18216 | 6011960.102969999 | 2102068.33335 | 37.7525529728507 | -122.401514142577 | (37.7525529728507, -122.401514142577) | ||
| 39240 | 39240 | 52917 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2606@ SCOTT Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 5 | Permit Number 48904 | 6001656.51059 | 2116675.28524 | 37.792079717356 | -122.438191960699 | (37.792079717356, -122.438191960699) | ||
| 39288 | 39288 | 72315 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3526 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 6 | 5997893.64237 | 2115823.01153 | 37.7895248738152 | -122.45114997549601 | (37.7895248738152, -122.451149975496) | ||
| 39418 | 39418 | 78260 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 567 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 7 | 6011132.1649400005 | 2092178.5330700001 | 37.7253514585786 | -122.40368151051202 | (37.7253514585786, -122.403681510512) | ||
| 39554 | 39554 | 38584 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015197.8625 | 2094625.9840000002 | 37.7322979479453 | -122.389797530007 | (37.7322979479453, -122.389797530007) | |
| 39626 | 39626 | 78781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997342.70536 | 2086993.5441299998 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | ||
| 39643 | 39643 | 46463 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 31 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | 8 | Permit Number 44667 | 6013974.3230800005 | 2095449.0350900001 | 37.7344899510581 | -122.39408521636801 | (37.7344899510581, -122.394085216368) | ||
| 39677 | 39677 | 71213 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2130 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 1 | 5988234.1964 | 2100800.0919 | 37.7477183038635 | -122.483468434844 | (37.7477183038635, -122.483468434844) | ||
| 40014 | 40014 | 97950 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||||
| 40267 | 40267 | 43856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43477 | 5985275.7006 | 2096383.1652 | 37.7354179757794 | -122.49337323491999 | (37.7354179757794, -122.49337323492) | |
| 40354 | 40354 | 53351 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2274 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | Permit Number 6244 | 5988266.9432 | 2099841.7174 | 37.7450887673736 | -122.483284958368 | (37.7450887673736, -122.483284958368) | |
| 40401 | 40401 | 246785 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Brewster St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010076.64553 | 2098710.46758 | 37.7432277379635 | -122.40779073774999 | (37.7432277379635, -122.40779073775) | ||||
| 40544 | 40544 | 73988 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3380 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 6 | 5998684.41396 | 2115276.24554 | 37.7880688417562 | -122.44837461191901 | (37.7880688417562, -122.448374611919) | ||
| 40588 | 40588 | 65111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 3 | Permit Number 27080 | 5989001.55724 | 2114468.21758 | 37.785291873757295 | -122.481815995928 | (37.7852918737573, -122.481815995928) | |
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 40778 | 40778 | 31726 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2457 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35224 | 5990124.6943 | 2098653.4978 | 37.741934165798995 | -122.47677445266599 | (37.741934165799, -122.476774452666) | |
| 40808 | 40808 | 235821 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1101 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004684.25074 | 2096286.8967900001 | 37.7362698092063 | -122.426263721818 | (37.7362698092063, -122.426263721818) | ||||
| 40927 | 40927 | 43854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2750 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43475 | 5985271.1902 | 2096508.1321 | 37.7357608377733 | -122.49339803308001 | (37.7357608377733, -122.49339803308) | |
| 41094 | 41094 | 68347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.48042050354601 | (37.7787654076266, -122.480420503546) | |
| 41106 | 41106 | 71157 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 807 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 7 | 6009578.493009999 | 2116131.05118 | 37.7910327500084 | -122.410743246197 | (37.7910327500084, -122.410743246197) | ||
| 41179 | 41179 | 31559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 178 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35104 | 5998526.8653 | 2112524.7682 | 37.7805049968836 | -122.448721445326 | (37.7805049968836, -122.448721445326) | ||
| 41417 | 41417 | 78412 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3035 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5989072.12667 | 2095062.74941 | 37.732013788304 | -122.480151113209 | (37.732013788304, -122.480151113209) | ||
| 41900 | 41900 | 66953 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 241 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | 3 | Permit Number 30282 | 5996650.5039099995 | 2111138.3656900004 | 37.7765908258581 | -122.455112415266 | (37.7765908258581, -122.455112415266) | |
| 41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
| 42033 | 42033 | 43829 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2676 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43457 | 5985566.531 | 2097143.2459 | 37.737521962445705 | -122.49242369498 | (37.7375219624457, -122.49242369498) | |
| 42153 | 42153 | 78510 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 750 Eucalyptus Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 3 | 5988931.24396 | 2094774.45392 | 37.731214015808796 | -122.480617072624 | (37.7312140158088, -122.480617072624) | ||
| 42191 | 42191 | 47070 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 610 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 7 | Permit Number 45053 | 6004032.90703 | 2110923.42535 | 37.7764214179404 | -122.429559210103 | (37.7764214179404, -122.429559210103) | |
| 42214 | 42214 | 70598 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 338 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004371.476319999 | 2091185.4336299999 | 37.722244643550894 | -122.426981885324 | (37.7222446435509, -122.426981885324) | ||
| 42301 | 42301 | 30496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1985 12:00:00 AM | 5 | Permit Number 22043 | 6001850.15003 | 2117377.4559 | 37.7940187069382 | -122.43757227473999 | (37.7940187069382, -122.43757227474) | ||
| 42365 | 42365 | 47394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 492 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995008.66399 | 2112223.96074 | 37.7794772512056 | -122.46087067285102 | (37.7794772512056, -122.460870672851) | |
| 42438 | 42438 | 65220 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 438 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 15 | Permit Number 28007 | 6002076.3517 | 2091079.52692 | 37.72182380131979 | -122.434908002604 | (37.7218238013198, -122.434908002604) | |
| 42481 | 42481 | 71284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | ||
| 42532 | 42532 | 51420 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 655 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013231.54034 | 2110531.34183 | 37.7758613840288 | -122.397710814302 | (37.7758613840288, -122.397710814302) | |
| 42579 | 42579 | 34802 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 314 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 5 | Permit Number 38438 | 5998143.868319999 | 2088884.5785 | 37.7155729168266 | -122.448343540327 | (37.7155729168266, -122.448343540327) | |
| 42655 | 42655 | 45085 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2310 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43967 | 5987349.47 | 2099507.712 | 37.7441182403398 | -122.486432860446 | (37.7441182403398, -122.486432860446) | |
| 42925 | 42925 | 67228 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 679 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 5 | Permit Number 30687 | 5983489.7095099995 | 2111188.94144 | 37.775965863323 | -122.500642433993 | (37.775965863323, -122.500642433993) | |
| 43008 | 43008 | 38589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1606 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40544 | 6015214.8687 | 2094687.4678 | 37.7324677131079 | -122.389743028049 | (37.7324677131079, -122.389743028049) | |
| 43101 | 43101 | 41909 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 774 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42272 | 5992600.74218 | 2110192.2118 | 37.7737597740758 | -122.46905271709 | (37.7737597740758, -122.46905271709) | |
| 43128 | 43128 | 196270 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | ||||
| 43152 | 43152 | 68657 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 243 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 8 | Permit Number 32564 | 5993662.97724 | 2113866.3239700003 | 37.7839092140163 | -122.46564528953002 | (37.7839092140163, -122.46564528953) | |
| 43205 | 43205 | 36955 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 375 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39586 | 5994624.16459 | 2113023.06924 | 37.7816492574469 | -122.46225878194201 | (37.7816492574469, -122.462258781942) | |
| 43248 | 43248 | 68349 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 527 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32168 | 5991569.001 | 2111811.09611 | 37.7781451219305 | -122.47273970036899 | (37.7781451219305, -122.472739700369) | |
| 43285 | 43285 | 38380 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 722 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1998 12:00:00 AM | 4 | Permit Number 40439 | 5990392.11079 | 2110429.52825 | 37.7742835191546 | -122.47670998353901 | (37.7742835191546, -122.476709983539) | ||
| 43576 | 43576 | 68892 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32864 | 6012556.44634 | 2091062.56254 | 37.7223666905441 | -122.398679591909 | (37.7223666905441, -122.398679591909) | |
| 43640 | 43640 | 72415 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3732 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996986.39697 | 2115040.92964 | 37.787325500813395 | -122.45423241709999 | (37.7873255008134, -122.4542324171) | ||
| 43723 | 43723 | 43544 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1808 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 10 | Permit Number 43209 | 6000435.9514 | 2111350.611 | 37.7773900427547 | -122.442032729545 | (37.7773900427547, -122.442032729545) | |
| 43727 | 43727 | 45086 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2310 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43967 | 5987348.1163 | 2099529.371 | 37.7441776312875 | -122.486439131059 | (37.7441776312875, -122.486439131059) | |
| 43838 | 43838 | 52448 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 431 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 4 | Permit Number 48560 | 5992472.90838 | 2112504.99178 | 37.780102654065 | -122.469663313675 | (37.780102654065, -122.469663313675) | |
| 43845 | 43845 | 236752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002107.159440001 | 2103370.74755 | 37.755574390960604 | -122.435680430326 | (37.7555743909606, -122.435680430326) | ||||
| 43909 | 43909 | 49837 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 610@ 18th ST San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46620 | 6010937.1736 | 2105420.43613 | 37.7616999711052 | -122.40528766280899 | (37.7616999711052, -122.405287662809) | |
| 44021 | 44021 | 43660 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 226 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 5 | Permit Number 43303 | 5992466.9959 | 2113900.33268 | 37.783933536641 | -122.469785383042 | (37.783933536641, -122.469785383042) | |
| 44335 | 44335 | 60787 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 210 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 6 | Permit Number 20460 | 5998412.8171 | 2112484.496 | 37.780387897645795 | -122.449113088127 | (37.7803878976458, -122.449113088127) | |
| 44470 | 44470 | 33977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 344 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | Permit Number 37920 | 5990607.48731 | 2113091.65197 | 37.781605467696295 | -122.47615944559799 | (37.7816054676963, -122.476159445598) | ||
| 44568 | 44568 | 47936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45671 | 5996315.56567541 | 2094902.75702129 | 37.7319927097789 | -122.45509757060199 | (37.7319927097789, -122.455097570602) | ||
| 44598 | 44598 | 31928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 440 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35344 | 5991750.017519999 | 2100486.13622 | 37.7470602654233 | -122.47128815772301 | (37.7470602654233, -122.471288157723) | |
| 44719 | 44719 | 71322 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | ||
| 44897 | 44897 | 67602 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 206 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 6 | Permit Number 31173 | 6013425.35879 | 2106076.07377 | 37.7636390047618 | -122.39672793716998 | (37.7636390047618, -122.39672793717) | |
| 44903 | 44903 | 212585 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 154 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999046.49545 | 2093810.2028700002 | 37.729149108537506 | -122.445577658299 | (37.7291491085375, -122.445577658299) | ||||
| 44957 | 44957 | 50214 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 890@ FULTON 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 5 | Permit Number 46922 | 5986992.86494 | 2109903.65169 | 37.7726418536031 | -122.488429783803 | (37.7726418536031, -122.488429783803) | |
| 44959 | 44959 | 68403 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 139 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 8 | Permit Number 32235 | 6002227.50379 | 2093953.23436 | 37.7297229344427 | -122.43459088726001 | (37.7297229344427, -122.43459088726) | |
| 45057 | 45057 | 70451 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | ||
| 45060 | 45060 | 70199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 5990281.69585 | 2112130.11385 | 37.778946453452896 | -122.477216227307 | (37.7789464534529, -122.477216227307) | ||
| 45067 | 45067 | 70144 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1993 12:00:00 AM | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | ||
| 45219 | 45219 | 52525 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | Permit Number 48625 | 6000708.298330001 | 2092511.5798799999 | 37.725678122036705 | -122.439739616589 | (37.7256781220367, -122.439739616589) | |
| 45225 | 45225 | 46825 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 307 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 4 | Permit Number 44902 | 6002873.310930001 | 2091679.1163 | 37.7235153577273 | -122.4321959207 | (37.7235153577273, -122.4321959207) | |
| 45294 | 45294 | 72250 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 360 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | ||
| 45385 | 45385 | 196287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012398.9699099995 | 2104759.28758 | 37.7599662220764 | -122.400185431124 | (37.7599662220764, -122.400185431124) | ||||
| 45509 | 45509 | 68562 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 5 | Permit Number 32452 | 5981948.24889 | 2112111.86912 | 37.7784093377083 | -122.50604310187401 | (37.7784093377083, -122.506043101874) | |
| 45510 | 45510 | 31694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 78 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35198 | 5998855.957 | 2107820.6304 | 37.7676074517958 | -122.447244305581 | (37.7676074517958, -122.447244305581) | |
| 45632 | 45632 | 49932 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2615@ VICENTE 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 1 | Permit Number 46692 | 5988614.8781 | 2097491.2622 | 37.73865527619321 | -122.48190973096901 | (37.7386552761932, -122.481909730969) | |
| 45658 | 45658 | 45648 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 161 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2005 12:00:00 AM | 3 | Permit Number 48327 | 6004350.27981 | 2092592.5951599998 | 37.7261072002806 | -122.427155337556 | (37.7261072002806, -122.427155337556) | |
| 45829 | 45829 | 70117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 6000875.3973900005 | 2088278.84235 | 37.714065490318106 | -122.438858781914 | (37.7140654903181, -122.438858781914) | ||
| 45865 | 45865 | 43858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2788 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43479 | 5985280.4764 | 2096241.4831 | 37.735029233793 | -122.49334628832399 | (37.735029233793, -122.493346288324) | |
| 45866 | 45866 | 35166 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 513 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 6 | Permit Number 38699 | 6002123.1918 | 2110352.0553 | 37.7747442642137 | -122.43612454697399 | (37.7747442642137, -122.436124546974) | |
| 45876 | 45876 | 61206 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 154 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 18 | Permit Number 21074 | 6011186.84016 | 2095845.15313 | 37.735422284496 | -122.403750383288 | (37.735422284496, -122.403750383288) | |
| 45968 | 45968 | 45498 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2963 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44272 | 5989312.49527 | 2095540.70737 | 37.7333401021585 | -122.479355070181 | (37.7333401021585, -122.479355070181) | |
| 45999 | 45999 | 56975 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1739 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 4 | Permit Number 14228 | 5986239.2634 | 2103387.2054 | 37.7547055025231 | -122.490557020674 | (37.7547055025231, -122.490557020674) | ||
| 46004 | 46004 | 212540 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993897.21452 | 2096501.63961 | 37.7362438080119 | -122.46357426156 | (37.7362438080119, -122.46357426156) | ||||
| 46055 | 46055 | 43307 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 8 | Permit Number 43073 | 6011299.88405 | 2104989.21526 | 37.7605362069949 | -122.40400283918301 | (37.7605362069949, -122.404002839183) | |
| 46060 | 46060 | 54016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 847 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1987 12:00:00 AM | 4 | Permit Number 24534 | 5985079.41944 | 2110081.62617 | 37.773018689528705 | -122.495061623329 | (37.7730186895287, -122.495061623329) | ||
| 46118 | 46118 | 38580 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1375 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40540 | 6016458.6044 | 2093690.7438 | 37.729799797257 | -122.385373666801 | (37.729799797257, -122.385373666801) | |
| 46255 | 46255 | 46806 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | |||
| 46446 | 46446 | 42145 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 474 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 6 | Permit Number 42440 | 5990638.82894 | 2112162.53163 | 37.7790561777006 | -122.475983142258 | (37.7790561777006, -122.475983142258) | |
| 46448 | 46448 | 196295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012406.535130001 | 2104796.6998799997 | 37.760069369818396 | -122.400161894071 | (37.7600693698184, -122.400161894071) | ||||
| 46545 | 46545 | 40821 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 695 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 3 | Permit Number 41762 | 6013333.5919699995 | 2110426.83484 | 37.7755801138616 | -122.39735045865 | (37.7755801138616, -122.39735045865) | ||
| 46562 | 46562 | 32656 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 567 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37088 | 6011442.785680001 | 2109776.31298 | 37.7736884771754 | -122.403845467717 | (37.7736884771754, -122.403845467717) | |
| 46566 | 46566 | 80849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 688-690 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | 6013555.65401 | 2103890.07686 | 37.757643986408894 | -122.39612407477699 | (37.7576439864089, -122.396124074777) | ||
| 46845 | 46845 | 59795 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 629 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1981 12:00:00 AM | 3 | Permit Number 19245 | 5992828.72485 | 2111169.43997 | 37.7764561494608 | -122.46833520393 | (37.7764561494608, -122.46833520393) | ||
| 46860 | 46860 | 62305 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 55 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 9 | Permit Number 22443 | 5996133.7949 | 2112337.61598 | 37.779853993369606 | -122.456986614452 | (37.7798539933696, -122.456986614452) | |
| 46945 | 46945 | 60784 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 114 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 3 | Permit Number 20454 | 5998687.9541 | 2112447.9464 | 37.7803032743536 | -122.448158632248 | (37.7803032743536, -122.448158632248) | |
| 46952 | 46952 | 72003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987539.672 | 2101751.7111 | 37.75029074773129 | -122.48593987171101 | (37.7502907477313, -122.485939871711) | ||
| 47150 | 47150 | 81654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | 6014140.03196 | 2096118.2922200002 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | ||
| 47454 | 47454 | 31832 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 229 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35289 | 6009612.2122 | 2109078.06285 | 37.7716688076043 | -122.410128425607 | (37.7716688076043, -122.410128425607) | |
| 47536 | 47536 | 63636 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 709 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/1993 12:00:00 AM | 4 | Permit Number 24282 | 6001017.1372 | 2111205.8703 | 37.7770257240718 | -122.440011841368 | (37.7770257240718, -122.440011841368) | |
| 47648 | 47648 | 43527 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1341 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 0 | Permit Number 43201 | 6001444.90531013 | 2110398.42991919 | 37.774833038264205 | -122.43847419690901 | (37.7748330382642, -122.438474196909) | |
| 47676 | 47676 | 64840 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 840 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1989 12:00:00 AM | 10 | Permit Number 25852 | 6012110.52355 | 2104463.76565 | 37.75913869652079 | -122.401162267538 | (37.7591386965208, -122.401162267538) | ||
| 47739 | 47739 | 37634 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 791 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40052 | 5990355.96275 | 2110068.04002 | 37.7732888747194 | -122.47680860775101 | (37.7732888747194, -122.476808607751) | |
| 47754 | 47754 | 78568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) |
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");