Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61834 | 61834 | 201616 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Innes Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021349.55513 | 2092801.0747099998 | 37.7276263098888 | -122.36840346285801 | (37.7276263098888, -122.368403462858) | |||
| 2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 33142 | 33142 | 201605 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 570 Innes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021066.69823 | 2093118.6837900002 | 37.7284828925695 | -122.369403250859 | (37.7284828925695, -122.369403250859) | |||
| 71242 | 71242 | 201604 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 570 Innes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021044.33252 | 2093135.00772 | 37.7285264880895 | -122.369481698744 | (37.7285264880895, -122.369481698744) | |||
| 59854 | 59854 | 201603 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 565 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6021043.02716 | 2093075.23068 | 37.7283622799705 | -122.369482082752 | (37.7283622799705, -122.369482082752) | |||
| 2402 | 2402 | 201606 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020954.32481 | 2093200.4635700001 | 37.7287012794353 | -122.36979738594101 | (37.7287012794353, -122.369797385941) | ||
| 2465 | 2465 | 201607 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020934.32673 | 2093214.8340900003 | 37.7287396409072 | -122.36986751418699 | (37.7287396409072, -122.369867514187) | ||
| 2433 | 2433 | 201610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 599 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770566 | 6020924.70462 | 2093166.9470099998 | 37.7286076240414 | -122.36989747059201 | (37.7286076240414, -122.369897470592) | |
| 176019 | 176019 | 201608 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6020912.48689 | 2093230.64881 | 37.7287818667771 | -122.369944109446 | (37.7287818667771, -122.369944109446) | |||
| 124573 | 124573 | 6444 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 141946 | 141946 | 6433 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 512 | 512 | 6424 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 12:46:00 PM | 3 | 3x3 | 6018234.67827 | 2096633.8011 | 37.7379789554566 | -122.37943787365299 | (37.7379789554566, -122.379437873653) | ||
| 1143 | 1143 | 6430 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 12:48:00 PM | 3 | 3x3 | 6018115.58754 | 2096722.72512 | 37.7382165545353 | -122.379855810196 | (37.7382165545353, -122.379855810196) | ||
| 16508 | 16508 | 6457 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2012 12:00:00 AM | 3 | 3x3 | 6018005.955469999 | 2096720.8825599998 | 37.7382054470215 | -122.38023473953699 | (37.7382054470215, -122.380234739537) | ||
| 14037 | 14037 | 6456 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2004 12:00:00 AM | 3 | 3X3 | 6017977.7328 | 2096742.9894400002 | 37.738264590924395 | -122.38033385651899 | (37.7382645909244, -122.380333856519) | ||
| 14855 | 14855 | 6455 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | 3X3 | 6017959.51846 | 2096757.36933 | 37.7383030702171 | -122.38039783251699 | (37.7383030702171, -122.380397832517) | ||
| 137848 | 137848 | 190417 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017947.81444 | 2096878.1348700002 | 37.738634022532295 | -122.380446690882 | (37.7386340225323, -122.380446690882) | |||
| 1140 | 1140 | 6454 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 02:46:00 PM | 3 | 3X3 | 6017932.4783 | 2096773.48366 | 37.738345824884895 | -122.380492444782 | (37.7383458248849, -122.380492444782) | ||
| 16673 | 16673 | 6453 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2009 12:00:00 AM | 3 | 3X3 | 6017908.60089 | 2096791.35092 | 37.7383935672065 | -122.380576243601 | (37.7383935672065, -122.380576243601) | ||
| 150793 | 150793 | 190418 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 13 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017880.91866 | 2096930.7090099999 | 37.7387746891043 | -122.38068164054701 | (37.7387746891043, -122.380681640547) | |||
| 13649 | 13649 | 6451 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017878.64833 | 2096818.1638599997 | 37.738465537256495 | -122.38068166932399 | (37.7384655372565, -122.380681669324) | ||
| 147177 | 147177 | 190419 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017844.32202 | 2096957.74462 | 37.7388469037738 | -122.380810054756 | (37.7388469037738, -122.380810054756) | |||
| 13976 | 13976 | 6449 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 3 | 3X3 | 6017844.2154 | 2096842.4719 | 37.7385303819825 | -122.380802412295 | (37.7385303819825, -122.380802412295) | ||
| 15184 | 15184 | 6448 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017830.617269999 | 2096853.12584 | 37.7385588850815 | -122.380850169009 | (37.7385588850815, -122.380850169009) | ||
| 46420 | 46420 | 190420 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017827.78919 | 2096970.1308799998 | 37.7388800015007 | -122.380868079005 | (37.7388800015007, -122.380868079005) | |||
| 16883 | 16883 | 6447 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2015 07:28:00 AM | 3 | 3X3 | 6017815.25315 | 2096866.6700099998 | 37.7385952266854 | -122.380904232644 | (37.7385952266854, -122.380904232644) | ||
| 44896 | 44896 | 190421 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 17 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017813.9736 | 2096980.8190099997 | 37.7389085864479 | -122.38091659022899 | (37.7389085864479, -122.380916590229) | |||
| 119928 | 119928 | 6452 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1195 Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/22/2012 12:00:00 AM | 3 | 3X3 | 6017800.8785909 | 2096864.2340113998 | 37.738587744527 | -122.38095376420601 | (37.738587744527, -122.380953764206) | ||
| 52901 | 52901 | 190422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 18 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6017797.18223 | 2096994.0322599998 | 37.7389439406012 | -122.38097556597299 | (37.7389439406012, -122.380975565973) | |||
| 9214 | 9214 | 6542 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6017765.684627299 | 2096901.7583544997 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | ||
| 78234 | 78234 | 6540 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 12:24:00 PM | 3 | 4X4 | 6017765.684627299 | 2096901.7583544997 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | ||
| 164173 | 164173 | 190423 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 21 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017743.92086 | 2097032.31488 | 37.739046117095704 | -122.381162382138 | (37.7390461170957, -122.381162382138) | |||
| 60979 | 60979 | 190447 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017726.41303 | 2096927.8119 | 37.7387582063175 | -122.381215652579 | (37.7387582063175, -122.381215652579) | |||
| 157330 | 157330 | 190424 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 22 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017710.59589 | 2097057.73864 | 37.7391140860314 | -122.38127937316901 | (37.7391140860314, -122.381279373169) | |||
| 157548 | 157548 | 190446 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017708.20702 | 2096943.20124 | 37.7387994573363 | -122.38127967082899 | (37.7387994573363, -122.381279670829) | |||
| 50394 | 50394 | 190425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 23 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017693.17965 | 2097070.35958 | 37.739147779140396 | -122.38134046861299 | (37.7391477791404, -122.381340468613) | |||
| 110022 | 110022 | 6466 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:10:00 PM | 3 | 5x3 | 6017691.374009999 | 2097075.6460099998 | 37.7391621949376 | -122.381347079263 | (37.7391621949376, -122.381347079263) | ||
| 37346 | 37346 | 190445 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017686.12557 | 2096959.12409 | 37.738841959282205 | -122.381357125839 | (37.7388419592822, -122.381357125839) | |||
| 45841 | 45841 | 190426 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 24 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017676.692919999 | 2097082.9618400002 | 37.7391814722423 | -122.381398348955 | (37.7391814722423, -122.381398348955) | |||
| 127207 | 127207 | 6467 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X3 | 6017673.482009999 | 2097089.9600099998 | 37.7392005105495 | -122.381409937459 | (37.7392005105495, -122.381409937459) | ||
| 55951 | 55951 | 190427 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 25 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017659.5138 | 2097095.8095900002 | 37.7392158011555 | -122.38145864041401 | (37.7392158011555, -122.381458640414) | |||
| 61401 | 61401 | 190428 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 26 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017641.63274 | 2097108.43991 | 37.7392494942632 | -122.38152134383101 | (37.7392494942632, -122.381521343831) | |||
| 39849 | 39849 | 190429 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 27 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017626.76379 | 2097120.54655 | 37.7392819157251 | -122.381573596257 | (37.7392819157251, -122.381573596257) | |||
| 20478 | 20478 | 6550 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1225X Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2013 12:00:00 AM | 3 | 4x4 | 6017625.4418446 | 2096995.6120179 | 37.738938797500296 | -122.381569480835 | (37.7389387975003, -122.381569480835) | ||
| 114126 | 114126 | 6546 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1225X Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2013 12:00:00 AM | 3 | 3x3 | 6017625.4418446 | 2096995.6120179 | 37.738938797500296 | -122.381569480835 | (37.7389387975003, -122.381569480835) | ||
| 79341 | 79341 | 6471 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017624.57801 | 2097125.7440099998 | 37.739296066226295 | -122.38158151514601 | (37.7392960662263, -122.381581515146) | ||
| 172543 | 172543 | 190430 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 28 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017590.10949 | 2097147.67735 | 37.7393543876054 | -122.381702218193 | (37.7393543876054, -122.381702218193) | |||
| 169860 | 169860 | 190431 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 29 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017575.221969999 | 2097158.85814 | 37.7393842657625 | -122.381754470602 | (37.7393842657625, -122.381754470602) | |||
| 102084 | 102084 | 6473 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 3 | 3X3 | 6017566.13101 | 2097162.72001 | 37.7393943676917 | -122.38178617198099 | (37.7393943676917, -122.381786171981) | ||
| 181258 | 181258 | 190432 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 31 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017540.84506 | 2097183.62792 | 37.739450380318395 | -122.38187505441499 | (37.7394503803184, -122.381875054415) | |||
| 158224 | 158224 | 190433 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 32 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017527.816819999 | 2097194.77168 | 37.739480259397205 | -122.381920875742 | (37.7394802593972, -122.381920875742) | |||
| 32001 | 32001 | 190434 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 33 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017509.45239 | 2097206.48557 | 37.739511409230104 | -122.381985187163 | (37.7395114092301, -122.381985187163) | |||
| 128724 | 128724 | 4902 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 94 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
| 79314 | 79314 | 6476 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017489.79301 | 2097227.1310099997 | 37.739567011757 | -122.38205459719299 | (37.739567011757, -122.382054597193) | ||
| 77777 | 77777 | 10729 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 99 Ardath Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | ||
| 55193 | 55193 | 190435 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 35 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017477.19545 | 2097232.60183 | 37.7395813377956 | -122.38209853501499 | (37.7395813377956, -122.382098535015) | |||
| 119286 | 119286 | 6478 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2013 12:00:00 AM | 3 | 3x3 | 6017452.81601 | 2097250.98701 | 37.739630473342 | -122.382184108102 | (37.739630473342, -122.382184108102) | ||
| 54625 | 54625 | 1412 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 87 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017443.0312922 | 2095232.0493547001 | 37.7340863325513 | -122.38207753310499 | (37.7340863325513, -122.382077533105) | ||
| 144982 | 144982 | 1403 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 62 Ardath Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017428.9119183 | 2095344.9938608997 | 37.734395675993795 | -122.382134203041 | (37.7343956759938, -122.382134203041) | ||
| 16450 | 16450 | 6552 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1275 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 2 | 3x3 | 6017428.8317 | 2097149.87395 | 37.7393515124558 | -122.38226000380101 | (37.7393515124558, -122.382260003801) | ||
| 91616 | 91616 | 1409 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 79 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017424.8922659 | 2095259.7862555 | 37.7341614907893 | -122.382142174898 | (37.7341614907893, -122.382142174898) | ||
| 23174 | 23174 | 6560 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1275 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/1998 12:00:00 AM | 5 | 3X3 | 6017410.001069999 | 2097164.07797 | 37.7393894737512 | -122.38232610038 | (37.7393894737512, -122.38232610038) | ||
| 172991 | 172991 | 190436 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 40 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017392.19785 | 2097295.20205 | 37.7397485307771 | -122.38239677720199 | (37.7397485307771, -122.382396777202) | |||
| 122398 | 122398 | 6482 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017388.40501 | 2097301.08401 | 37.739764471951396 | -122.38241030049801 | (37.7397644719514, -122.382410300498) | ||
| 13383 | 13383 | 6551 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1275 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6017377.10796 | 2097187.95737 | 37.7394532248805 | -122.382441492395 | (37.7394532248805, -122.382441492395) | ||
| 182036 | 182036 | 190437 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 41 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017375.251180001 | 2097308.04531 | 37.73978285968779 | -122.382456265548 | (37.7397828596878, -122.382456265548) | |||
| 107899 | 107899 | 6481 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2004 12:00:00 AM | 3 | 3X3 | 6017370.51401 | 2097316.59001 | 37.7398060600402 | -122.38247323921001 | (37.7398060600402, -122.38247323921) | ||
| 16530 | 16530 | 6557 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1295 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017327.79614 | 2097225.14211 | 37.7395526026726 | -122.38261457951201 | (37.7395526026726, -122.382614579512) | ||
| 15136 | 15136 | 6556 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1295 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1997 12:00:00 AM | 3 | 3X3 | 6017308.64895 | 2097239.18487 | 37.7395901034918 | -122.382681759772 | (37.7395901034918, -122.382681759772) | ||
| 107138 | 107138 | 1392 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 22 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017289.005730201 | 2095457.8512491002 | 37.7346978320202 | -122.382625759658 | (37.7346978320202, -122.382625759658) | ||
| 107859 | 107859 | 1389 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017228.6912616 | 2095462.3520099 | 37.7347068580177 | -122.38283460251301 | (37.7347068580177, -122.382834602513) | ||
| 36209 | 36209 | 190444 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017091.55638 | 2097401.29734 | 37.7400232358798 | -122.383443661803 | (37.7400232358798, -122.383443661803) | |||
| 15902 | 15902 | 108047 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 3x3 | 6017036.144669999 | 2097442.01922 | 37.7401319873023 | -122.383638088928 | (37.7401319873023, -122.383638088928) | ||
| 102807 | 102807 | 6499 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017004.32701 | 2097592.12501 | 37.7405423887708 | -122.38375855101201 | (37.7405423887708, -122.383758551012) | ||
| 95212 | 95212 | 6501 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 3 | 3x3 | 6016955.42201 | 2097623.1370099997 | 37.740624838003896 | -122.383929806075 | (37.7406248380039, -122.383929806075) | ||
| 88688 | 88688 | 6504 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3X3 | 6016904.13201 | 2097662.49901 | 37.7407300825378 | -122.38410988935699 | (37.7407300825378, -122.384109889357) | ||
| 158666 | 158666 | 190443 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1355 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6016894.71914 | 2097547.52452 | 37.74041386541771 | -122.384134431075 | (37.7404138654177, -122.384134431075) | |||
| 72587 | 72587 | 6505 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3x3 | 6016887.43301 | 2097676.8130099997 | 37.7407684626261 | -122.38416862532 | (37.7407684626261, -122.38416862532) | ||
| 39886 | 39886 | 190442 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1355 Evans Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6016877.61035 | 2097560.61603 | 37.740448866128204 | -122.384194498593 | (37.7404488661282, -122.384194498593) | |||
| 143134 | 143134 | 6506 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3x3 | 6016870.73401 | 2097688.74101 | 37.7408002912118 | -122.38422719521799 | (37.7408002912118, -122.384227195218) | ||
| 84767 | 84767 | 6507 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3X3 | 6016854.03501 | 2097699.47601 | 37.740828844031604 | -122.38428568209999 | (37.7408288440316, -122.3842856821) | ||
| 107950 | 107950 | 6587 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1375 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6016853.0670442 | 2097574.0145521997 | 37.740484298731204 | -122.38428029344801 | (37.7404842987312, -122.384280293448) | ||
| 142445 | 142445 | 6592 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1375 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 6 | 3X3 | 6016853.0670442 | 2097574.0145521997 | 37.740484298731204 | -122.38428029344801 | (37.7404842987312, -122.384280293448) | ||
| 113679 | 113679 | 44254 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1375 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.38428155142701 | (37.7404816352752, -122.384281551427) | |||
| 69038 | 69038 | 190440 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1350 Evans Ave | 7 | : 4 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 4 | Width 3ft | 6016842.64833 | 2097703.08966 | 37.740838136776794 | -122.384325304974 | (37.7408381367768, -122.384325304974) | ||
| 89786 | 89786 | 6508 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3X3 | 6016839.72201 | 2097711.4040099997 | 37.7408608044909 | -122.38433600211599 | (37.7408608044909, -122.384336002116) | ||
| 164889 | 164889 | 190441 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1355 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016833.46344 | 2097593.1444200003 | 37.74053574152661 | -122.384349407722 | (37.7405357415266, -122.384349407722) | |||
| 15866 | 15866 | 6595 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016681.72094 | 2097824.21819 | 37.741161831548794 | -122.38489017364799 | (37.7411618315488, -122.384890173648) | ||
| 15900 | 15900 | 6596 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016665.24254 | 2097836.86612 | 37.741195648757206 | -122.384948031546 | (37.7411956487572, -122.384948031546) | ||
| 79281 | 79281 | 16528 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1420X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.741239457182104 | -122.38500415558701 | (37.7412394571821, -122.385004155587) | ||
| 102678 | 102678 | 16534 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1420X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2004 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.741239457182104 | -122.38500415558701 | (37.7412394571821, -122.385004155587) | ||
| 114963 | 114963 | 16530 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1420X Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6016649.3386754 | 2097853.1412174 | 37.741239457182104 | -122.38500415558701 | (37.7412394571821, -122.385004155587) | ||
| 140093 | 140093 | 16535 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1420X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.741239457182104 | -122.38500415558701 | (37.7412394571821, -122.385004155587) | ||
| 16016 | 16016 | 6627 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1415 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016607.54293 | 2097762.50213 | 37.740988268684895 | -122.385142357926 | (37.7409882686849, -122.385142357926) | ||
| 16668 | 16668 | 6626 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.825619999 | 2097781.51455 | 37.741038994951204 | -122.38523606192 | (37.7410389949512, -122.38523606192) | ||
| 15389 | 15389 | 6625 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1415 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016564.1874 | 2097795.2525 | 37.7410757961225 | -122.385294548421 | (37.7410757961225, -122.385294548421) | ||
| 13468 | 13468 | 6601 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016563.26404 | 2097911.91125 | 37.7413960662634 | -122.38530586818099 | (37.7413960662634, -122.385305868181) |
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");