Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1824 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
3276 | 3276 | 149033 | Permitted Site 1 | :: 54 | 3916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2017 12:00:00 AM | 3 | 5.5x12 | 5996085.364440001 | 2114918.02173 | 37.7869363183091 | -122.45734088598302 | (37.7869363183091, -122.457340885983) | ||
5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
18795 | 18795 | 31192 | Permitted Site 1 | :: 54 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
19176 | 19176 | 36500 | Permitted Site 1 | :: 54 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.741839715130894 | -122.41513812883001 | (37.7418397151309, -122.41513812883) | ||
19242 | 19242 | 36516 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
20493 | 20493 | 31189 | Permitted Site 1 | :: 54 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
30528 | 30528 | 36517 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
51323 | 51323 | 33210 | Permitted Site 1 | :: 54 | 80 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
54627 | 54627 | 36527 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
61493 | 61493 | 105361 | Permitted Site 1 | :: 54 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
77581 | 77581 | 33407 | Permitted Site 1 | :: 54 | 100 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
77582 | 77582 | 37456 | Permitted Site 1 | :: 54 | 442 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.743020676259704 | -122.40723276795299 | (37.7430206762597, -122.407232767953) | ||
77940 | 77940 | 114567 | Permitted Site 1 | :: 54 | 1930 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2015 12:00:00 AM | 3x3 | 6008702.7 | 2119505.5 | 37.8002490116896 | -122.414012289596 | (37.8002490116896, -122.414012289596) | ||
78123 | 78123 | 104843 | Permitted Site 1 | :: 54 | 1320 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989622.0 | 2106334.7 | 37.7629955389606 | -122.47907431964701 | (37.7629955389606, -122.479074319647) | ||||||
78333 | 78333 | 38003 | Permitted Site 1 | :: 54 | 2478 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2002 12:00:00 AM | Permit Number 40215 | 5992069.67302471 | 2098579.11634993 | 37.74184256230679 | -122.47004399101499 | (37.7418425623068, -122.470043991015) | ||
78529 | 78529 | 43025 | Permitted Site 1 | :: 54 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051004 | -122.429193705112 | (37.774709297051, -122.429193705112) | ||
78656 | 78656 | 35996 | Permitted Site 1 | :: 54 | 36 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39146 | 6007490.93822931 | 2099869.27557104 | 37.7462644727809 | -122.416813538412 | (37.7462644727809, -122.416813538412) | ||
79062 | 79062 | 33409 | Permitted Site 1 | :: 54 | 100 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
80004 | 80004 | 35095 | Permitted Site 1 | :: 54 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.718911055862606 | -122.43365900206499 | (37.7189110558626, -122.433659002065) | ||
80342 | 80342 | 36993 | Permitted Site 1 | :: 54 | 2974 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39613 | 6008419.31343349 | 2103324.4841573997 | 37.7558038738313 | -122.413847688409 | (37.7558038738313, -122.413847688409) | ||
81123 | 81123 | 36532 | Permitted Site 1 | :: 54 | 3734St. Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39405 | 6008419.88910724 | 2097501.78967285 | 37.7398160862313 | -122.413433924041 | (37.7398160862313, -122.413433924041) | ||
81482 | 81482 | 38110 | Permitted Site 1 | :: 54 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
81521 | 81521 | 34737 | Permitted Site 1 | :: 54 | 575 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38387 | 6007300.76294173 | 2103973.10640079 | 37.757521960416604 | -122.41776197976499 | (37.7575219604166, -122.417761979765) | ||
81650 | 81650 | 45785 | Permitted Site 1 | :: 54 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2001 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | |||
81995 | 81995 | 37632 | Permitted Site 1 | :: 54 | 791 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40050 | 5990357.50342651 | 2110002.09732806 | 37.773107903504794 | -122.476798459473 | (37.7731079035048, -122.476798459473) | ||
82222 | 82222 | 32457 | Permitted Site 1 | :: 54 | 210 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36972 | 6003808.4224833 | 2109079.21792679 | 37.771344964126705 | -122.430204165931 | (37.7713449641267, -122.430204165931) | ||
83254 | 83254 | 110159 | Permitted Site 1 | :: 54 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | |||
83497 | 83497 | 105359 | Permitted Site 1 | :: 54 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
83697 | 83697 | 108792 | Permitted Site 1 | :: 54 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
83937 | 83937 | 33209 | Permitted Site 1 | :: 54 | 80 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
84755 | 84755 | 34736 | Permitted Site 1 | :: 54 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38386 | 6007298.90712997 | 2104006.62448648 | 37.7576138889301 | -122.417770773708 | (37.7576138889301, -122.417770773708) | ||
85159 | 85159 | 108793 | Permitted Site 1 | :: 54 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
85267 | 85267 | 46322 | Permitted Site 1 | :: 54 | 3080 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | Permit Number 44576 | 5988871.55058969 | 2094853.71729449 | 37.731428183192705 | -122.480829241755 | (37.7314281831927, -122.480829241755) | |||
85350 | 85350 | 40070 | Permitted Site 1 | :: 54 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | ||
85364 | 85364 | 115892 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
85490 | 85490 | 52296 | Permitted Site 1 | :: 54 | 677DIAMOND ST Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48457 | 6002165.96993722 | 2099704.44459938 | 37.7455109340163 | -122.435214819168 | (37.7455109340163, -122.435214819168) | ||
86204 | 86204 | 33463 | Permitted Site 1 | :: 54 | 20 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | ||
86244 | 86244 | 41853 | Permitted Site 1 | :: 54 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42240 | 5992008.2421953 | 2105257.75589238 | 37.7601768237518 | -122.470742754033 | (37.7601768237518, -122.470742754033) | ||
86957 | 86957 | 109262 | Permitted Site 1 | :: 54 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
87303 | 87303 | 33408 | Permitted Site 1 | :: 54 | 100 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
87372 | 87372 | 33510 | Permitted Site 1 | :: 54 | 24 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37605 | 6006962.93911675 | 2099621.40648906 | 37.745554167617 | -122.418621725138 | (37.745554167617, -122.418621725138) | |||
88172 | 88172 | 33514 | Permitted Site 1 | :: 54 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37614 | 6006108.24130768 | 2097930.15080676 | 37.7408622046731 | -122.421457054715 | (37.7408622046731, -122.421457054715) | ||
89025 | 89025 | 36518 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
89307 | 89307 | 105925 | Permitted Site 1 | :: 54 | 4166 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6002608.6 | 2104160.0 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | |||||
89497 | 89497 | 30705 | Permitted Site 1 | :: 54 | 371 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34615 | 6005225.74804899 | 2110232.43831944 | 37.7745916029272 | -122.425383648395 | (37.7745916029272, -122.425383648395) | ||
91070 | 91070 | 105360 | Permitted Site 1 | :: 54 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
91200 | 91200 | 33411 | Permitted Site 1 | :: 54 | 100 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
92236 | 92236 | 43021 | Permitted Site 1 | :: 54 | 537 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | |||
92536 | 92536 | 114785 | Permitted Site 1 | :: 54 | 2459 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 6000398.9 | 2113706.0 | 37.7838552262656 | -122.44233003645701 | (37.7838552262656, -122.442330036457) | ||||
92619 | 92619 | 115024 | Permitted Site 1 | :: 54 | 2500 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 5983385.7 | 2098079.0 | 37.739963544351504 | -122.500032889381 | (37.7399635443515, -122.500032889381) | ||||
93908 | 93908 | 51029 | Permitted Site 1 | :: 54 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3x3 | Permit Number 767941 | 6007256.96585115 | 2097027.84886938 | 37.7384493854458 | -122.417421253654 | (37.7384493854458, -122.417421253654) | ||
93962 | 93962 | 115298 | Permitted Site 1 | :: 54 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | |||||
94877 | 94877 | 42090 | Permitted Site 1 | :: 54 | 25 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | ||
98032 | 98032 | 114972 | Permitted Site 1 | :: 54 | 1431 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | 6000962.5 | 2110659.8 | 37.775523242518794 | -122.440161680014 | (37.7755232425188, -122.440161680014) | |||
98575 | 98575 | 115891 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
99156 | 99156 | 33410 | Permitted Site 1 | :: 54 | 100 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
99253 | 99253 | 117318 | Permitted Site 1 | :: 54 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||||
100579 | 100579 | 117313 | Permitted Site 1 | :: 54 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981355.6 | 2109736.3 | 37.7718518197324 | -122.50791691513099 | (37.7718518197324, -122.507916915131) | |||||
100825 | 100825 | 33462 | Permitted Site 1 | :: 54 | 20 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | ||
101195 | 101195 | 115894 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
101816 | 101816 | 31149 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
102292 | 102292 | 33205 | Permitted Site 1 | :: 54 | 80 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
103251 | 103251 | 38126 | Permitted Site 1 | :: 54 | 2822 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40290 | 5987014.20991985 | 2106446.11642248 | 37.7631496691658 | -122.488101839973 | (37.7631496691658, -122.488101839973) | ||
104076 | 104076 | 35147 | Permitted Site 1 | :: 54 | 218 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38679 | 6003802.50848229 | 2109121.89341149 | 37.7714618056141 | -122.430227667803 | (37.7714618056141, -122.430227667803) | ||
104342 | 104342 | 95908 | Permitted Site 1 | :: 54 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767609 | 5987396.4 | 2105326.0 | 37.760096425656705 | -122.486697735896 | (37.7600964256567, -122.486697735896) | |
105387 | 105387 | 117319 | Permitted Site 1 | :: 54 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||||
107393 | 107393 | 33714 | Permitted Site 1 | :: 54 | 171 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37781 | 6003460.14310315 | 2108772.24359779 | 37.770482355194105 | -122.431386962618 | (37.7704823551941, -122.431386962618) | ||
109627 | 109627 | 43024 | Permitted Site 1 | :: 54 | 430 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051004 | -122.429193705112 | (37.774709297051, -122.429193705112) | ||
109892 | 109892 | 36905 | Permitted Site 1 | :: 54 | 4416 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39553 | 6000517.15649148 | 2102301.36938584 | 37.7525476968755 | -122.441102423403 | (37.7525476968755, -122.441102423403) | ||
110326 | 110326 | 37315 | Permitted Site 1 | :: 54 | 561 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39830 | 6002709.44183784 | 2103247.60813838 | 37.7552704710237 | -122.43358875215 | (37.7552704710237, -122.43358875215) | ||
110336 | 110336 | 52107 | Permitted Site 1 | :: 54 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | ||
110497 | 110497 | 38040 | Permitted Site 1 | :: 54 | 271 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40242 | 5992319.7729488 | 2097504.33557698 | 37.7389059415194 | -122.46910103166401 | (37.7389059415194, -122.469101031664) | ||
110521 | 110521 | 37485 | Permitted Site 1 | :: 54 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341002 | (37.7640707487715, -122.47510458341) | ||
110733 | 110733 | 33206 | Permitted Site 1 | :: 54 | 80 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
111037 | 111037 | 43020 | Permitted Site 1 | :: 54 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | ||
113475 | 113475 | 46634 | Permitted Site 1 | :: 54 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.185840401 | 2093576.72961431 | 37.729391461068204 | -122.391309972305 | (37.7293914610682, -122.391309972305) | ||
113500 | 113500 | 109261 | Permitted Site 1 | :: 54 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
114617 | 114617 | 105046 | Permitted Site 1 | :: 54 | 268 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | ||||||
114951 | 114951 | 33208 | Permitted Site 1 | :: 54 | 80 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
116859 | 116859 | 45263 | Permitted Site 1 | :: 54 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | ||
117141 | 117141 | 115013 | Permitted Site 1 | :: 54 | 2493 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 5999602.09209 | 2119817.77431 | 37.8005911003042 | -122.44552631681499 | (37.8005911003042, -122.445526316815) | ||||
117766 | 117766 | 37180 | Permitted Site 1 | :: 54 | 41 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39753 | 6005613.02354759 | 2099315.01435949 | 37.7446367918581 | -122.42326775451299 | (37.7446367918581, -122.423267754513) | ||
118121 | 118121 | 36924 | Permitted Site 1 | :: 54 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39568 | 6001154.35821609 | 2103257.26025902 | 37.755208616744795 | -122.438967374074 | (37.7552086167448, -122.438967374074) | ||
118134 | 118134 | 36519 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) |
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");