home / trees

Street_Tree_List

Data source: data.sfgov.org

8,704 rows where qSpecies = 3

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
3 1000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1726 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X5PL   6001385.76767 2092068.0675700002 37.724498876108 -122.43736591900499 (37.724498876108, -122.437365919005) 9 7 6 28861 25
171 100168 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 710 El Camino Del Mar 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671) 11 6 1 55 33
186 100184 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 480 Oxford St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6006818.05082 2091764.69226 37.7239732025834 -122.418565697766 (37.7239732025834, -122.418565697766) 9 7 7 309 28
220 100216 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 527-529 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003013.0 2105186.0 37.7606100501577 -122.43267741654199 (37.7606100501577, -122.432677416542) 2 4 5 28862 3
221 100217 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 527-529 Noe St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003013.0 2105186.0 37.7606100501577 -122.43267741654199 (37.7606100501577, -122.432677416542) 2 4 5 28862 3
337 100352 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 4329 Lincoln Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     0 3x3 Permit Number 769248 5982262.3 2106887.2 37.764082394026396 -122.504569504513 (37.7640823940264, -122.504569504513) 1 8 3 56 35
482 100534 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 2524 Clay St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/03/2012 12:00:00 AM 5   Permit Number 769201 6002650.71581 2116155.36871 37.7907086541232 -122.43471480844102 (37.7907086541232, -122.434714808441) 13 9 1 29490 27
510 100563 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 284 O'Farrell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6009946.4 2114395.0 37.7862865916342 -122.409347728871 (37.7862865916342, -122.409347728871) 5 10 10 28852 36
511 100564 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 312 Mason St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6009858.0 2114440.0 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
512 100565 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 312 Mason St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6009858.0 2114440.0 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
513 100566 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 312 Mason St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6009858.0 2114440.0 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
514 100567 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 312 Mason St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6009858.0 2114440.0 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
612 100692 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 685X Howard St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/2012 12:00:00 AM 10 4x4 Permit Number 769119 6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
623 100702 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 685X Howard St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
624 100703 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 685X Howard St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
625 100704 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 685X Howard St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
630 100709 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 685X Howard St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
634 100712 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 201 03rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/07/2016 12:00:00 AM 3 4x4 Permit Number 777720 6012642.07844 2113780.85494 37.784750955827604 -122.399978174254 (37.7847509558276, -122.399978174254) 6 2 9 28853 6
635 100713 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 201 03rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 4x4   6012618.71345 2113808.99095 37.7848269080754 -122.400060986537 (37.7848269080754, -122.400060986537) 6 2 9 28853 6
636 100714 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 201 03rd St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6012602.76589 2113824.0281 37.7848673074186 -122.40011721666201 (37.7848673074186, -122.400117216662) 6 2 9 28853 6
638 100716 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 201 03rd St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 4x4   6012588.83834 2113836.6702799997 37.7849012433369 -122.40016628996099 (37.7849012433369, -122.400166289961) 6 2 9 28853 6
639 100717 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 201 03rd St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6012575.24779 2113851.36546 37.7849408350855 -122.400214341625 (37.7849408350855, -122.400214341625) 6 2 9 28853 6
640 100718 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 201 03rd St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 4x4   6012561.603490001 2113863.41333 37.7849731549205 -122.400262393299 (37.7849731549205, -122.400262393299) 6 2 9 28853 6
731 100815 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1324 45th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/24/2012 12:00:00 AM 0   Permit Number 769327 5982180.1 2106070.8 37.7618359578506 -122.50479330774701 (37.7618359578506, -122.504793307747) 1 8 3 56 35
800 1009 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1833 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3X3   6001322.10095 2091567.1902700001 37.723119960895794 -122.437550153242 (37.7231199608958, -122.437550153242) 9 7 6 28861 25
934 101091 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1202 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5990254.0041 2103161.7012 37.75432001295321 -122.47665663135099 (37.7543200129532, -122.476656631351) 1 8 3 56 35
935 101092 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1200 Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5990310.3 2103151.6 37.754295542880605 -122.47646121006599 (37.7542955428806, -122.476461210066) 1 8 3 56 35
936 101093 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1200 Noriega St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5990310.3 2103151.6 37.754295542880605 -122.47646121006599 (37.7542955428806, -122.476461210066) 1 8 3 56 35
937 101094 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1222 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   5990152.5013 2103157.8184 37.754303463857205 -122.477007366297 (37.7543034638572, -122.477007366297) 1 8 3 56 35
941 101098 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1422 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   5989556.7476 2103146.7648 37.75423853417521 -122.47906680161199 (37.7542385341752, -122.479066801612) 1 8 3 56 35
943 101100 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1450 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   5989483.3887 2103142.2154 37.754221782261794 -122.479320159356 (37.7542217822618, -122.479320159356) 1 8 3 56 35
944 101101 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1450 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5989527.0 2103139.0 37.7542154865121 -122.479169107121 (37.7542154865121, -122.479169107121) 1 8 3 56 35
945 101102 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1450 Noriega St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   5989444.1502 2103141.6467 37.754217941681105 -122.479455812722 (37.7542179416811, -122.479455812722) 1 8 3 56 35
946 101103 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1516 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   5989287.5149 2103137.0833 37.7541963124281 -122.479997156441 (37.7541963124281, -122.479997156441) 1 8 3 56 35
948 101105 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1642 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5988844.2998 2103124.2167 37.7541352231255 -122.481528943789 (37.7541352231255, -122.481528943789) 1 8 3 56 35
949 101106 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1650 Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 14066 5988798.3084 2103123.6691 37.7541310452569 -122.481687951334 (37.7541310452569, -122.481687951334) 1 8 3 56 35
954 101110 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1700 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   5988671.0107 2103117.3727 37.7541063538101 -122.482127711453 (37.7541063538101, -122.482127711453) 1 8 3 56 35
955 101111 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1728 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   5988603.6661 2103114.0876 37.7540934165996 -122.48236036202299 (37.7540934165996, -122.482360362023) 1 8 3 56 35
956 101112 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1611 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5988946.0821 2103051.1539 37.7539405298718 -122.481171610101 (37.7539405298718, -122.481171610101) 1 8 3 56 35
957 101113 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1443 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5989445.324 2103065.4711 37.754008851942395 -122.47944618073099 (37.7540088519424, -122.479446180731) 1 8 3 56 35
958 101114 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1443 Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5989504.1745 2103066.6722 37.75401556797021 -122.479242751781 (37.7540155679702, -122.479242751781) 1 8 3 56 35
959 101115 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1425 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   5989531.7982 2103069.0742 37.7540237675288 -122.479147399181 (37.7540237675288, -122.479147399181) 1 8 3 56 35
960 101116 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1401 Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10   Permit Number 17026 5989636.2879 2103075.0794 37.7540463239751 -122.478786491943 (37.7540463239751, -122.478786491943) 1 8 3 56 35
961 101117 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 1401 Noriega St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 17026 5989684.0 2103075.0 37.7540488762587 -122.478621488038 (37.7540488762587, -122.478621488038) 1 8 3 56 35
962 101118 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1239 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16   Permit Number 17026 5990136.9434 2103098.5473 37.7541398185385 -122.477056838029 (37.7541398185385, -122.477056838029) 1 8 3 56 35
963 101119 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 1201 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 17026 5989684.0 2103075.0 37.7540488762587 -122.478621488038 (37.7540488762587, -122.478621488038) 1 8 3 56 35
965 101120 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 1201x Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 17026 5990269.0 2103025.0 37.7539455374003 -122.47659478608101 (37.7539455374003, -122.476594786081) 1 8 3 56 35
966 101121 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 1201 Noriega St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 17026 5990311.7 2103111.6 37.7541857946529 -122.476453446723 (37.7541857946529, -122.476453446723) 1 8 3 56 35
987 101141 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 755 Rhode Island St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 5x9   6011868.75409 2104860.94697 37.7602157776524 -122.402026348736 (37.7602157776524, -122.402026348736) 10 3 8 28856 29
1024 101175 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 400 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994553.0 2106706.0 37.7643001590155 -122.462046733301 (37.7643001590155, -122.462046733301) 11 5 11 56 12
1025 101176 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 400 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994553.0 2106706.0 37.7643001590155 -122.462046733301 (37.7643001590155, -122.462046733301) 11 5 11 56 12
1026 101177 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 408 IRVING ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994501.0 2106722.0 37.7643410968681 -122.462227745791 (37.7643410968681, -122.462227745791) 11 5 11 56 12
1028 101179 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1295X 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994535.9 2106711.8 37.764315099776795 -122.46210629759199 (37.7643150997768, -122.462106297592) 11 5 11 56 12
1031 101181 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 357 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994691.0 2106655.0 37.7641680705078 -122.46156573588199 (37.7641680705078, -122.461565735882) 15 5 11 56 12
1032 101182 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 357 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994691.0 2106655.0 37.7641680705078 -122.46156573588199 (37.7641680705078, -122.461565735882) 15 5 11 56 12
1033 101183 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 357 Irving St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994691.0 2106655.0 37.7641680705078 -122.46156573588199 (37.7641680705078, -122.461565735882) 15 5 11 56 12
1038 101188 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 300 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994863.0 2106716.0 37.764345459457004 -122.460975263176 (37.764345459457, -122.460975263176) 15 5 11 56 12
1044 101193 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 390X Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994589.6 2106699.6 37.764284693418205 -122.46191968102801 (37.7642846934182, -122.461919681028) 15 5 11 56 12
1045 101194 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 390X Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994589.6 2106699.6 37.764284693418205 -122.46191968102801 (37.7642846934182, -122.461919681028) 15 5 11 56 12
1046 101195 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 390X Irving St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994589.6 2106699.6 37.764284693418205 -122.46191968102801 (37.7642846934182, -122.461919681028) 15 5 11 56 12
1047 101196 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1290 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994636.2 2106777.6 37.764501543786395 -122.461764161989 (37.7645015437864, -122.461764161989) 15 5 11 56 12
1048 101197 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1290 05th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994636.2 2106777.6 37.764501543786395 -122.461764161989 (37.7645015437864, -122.461764161989) 15 5 11 56 12
1049 101198 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1290 05th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994636.2 2106777.6 37.764501543786395 -122.461764161989 (37.7645015437864, -122.461764161989) 15 5 11 56 12
1267 101435 Significant Tree 4 Metrosideros excelsa :: New Zealand Xmas Tree 3 600X Grant Ave 1 Front Yard : Yard 4 Tree 1 Private 2           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
1268 101436 Significant Tree 4 Metrosideros excelsa :: New Zealand Xmas Tree 3 600X Grant Ave 2 Front Yard : Yard 4 Tree 1 Private 2           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
1270 101438 Significant Tree 4 Metrosideros excelsa :: New Zealand Xmas Tree 3 600X Grant Ave 3 Front Yard : Yard 4 Tree 1 Private 2           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
1271 101439 Significant Tree 4 Metrosideros excelsa :: New Zealand Xmas Tree 3 600X Grant Ave 4 Front Yard : Yard 4 Tree 1 Private 2           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
1273 101440 Significant Tree 4 Metrosideros excelsa :: New Zealand Xmas Tree 3 600X Grant Ave 5 Front Yard : Yard 4 Tree 1 Private 2           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
1322 1015 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1854X Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 4X4   6001128.27711 2091386.71553 37.7226133962853 -122.43820724002899 (37.7226133962853, -122.438207240029) 9 7 6 28861 25
1410 101592 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1 Daniel Burnham Ct 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.42248241113899 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
1411 101593 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1 Daniel Burnham Ct 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.42248241113899 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
1412 101594 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1 Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.42248241113899 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
1413 101595 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1 Daniel Burnham Ct 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.42248241113899 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
1414 101597 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1 Daniel Burnham Ct 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.42248241113899 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
1416 101600 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1 Daniel Burnham Ct 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.42248241113899 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
1468 10166 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 1020 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/22/2013 12:00:00 AM 70 2X3 Permit Number 769235 6005686.718472401 2103018.6198444 37.754810200535104 -122.42327615338199 (37.7548102005351, -122.423276153382) 2 4 5 28859 19
1469 101661 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1470 101663 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1471 101664 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1472 101665 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1473 101666 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1474 101667 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1475 101668 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1477 101670 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1478 101671 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1479 101674 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1480 101675 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1481 101676 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 16 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1486 101680 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 201X San Leandro Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992417.5 2095390.1 37.7331064279943 -122.46860934798 (37.7331064279943, -122.46860934798) 9 8 4 59 40
1487 101681 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 201X San Leandro Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992417.5 2095390.1 37.7331064279943 -122.46860934798 (37.7331064279943, -122.46860934798) 9 8 4 59 40
1492 101686 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 3701 Sacramento St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     5997129.96175 2115018.98612 37.787273481345295 -122.453734130627 (37.7872734813453, -122.453734130627) 11 6 1 54 31
1493 101687 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 415X Spruce St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5997168.0 2115063.0 37.787396512388604 -122.45360570636002 (37.7873965123886, -122.45360570636) 11 6 1 54 31
1494 101688 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 415X Spruce St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5997168.0 2115063.0 37.787396512388604 -122.45360570636002 (37.7873965123886, -122.45360570636) 11 6 1 54 31
1495 101689 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 415X Spruce St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5997168.0 2115063.0 37.787396512388604 -122.45360570636002 (37.7873965123886, -122.45360570636) 11 6 1 54 31
1497 101690 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 415X Spruce St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997168.0 2115063.0 37.787396512388604 -122.45360570636002 (37.7873965123886, -122.45360570636) 11 6 1 54 31
1539 101734 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 350 Dwight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6010571.05211 2091409.5046700002 37.7232085054565 -122.40556709566201 (37.7232085054565, -122.405567095662) 10 3 7 309 28
1606 101842 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 17 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1607 101843 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 2X Daniel Burnham Ct 18 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1642 101901 Property Tree 5 Metrosideros excelsa :: New Zealand Xmas Tree 3 1100 Ocean Ave 2 Front Yard : Yard 4 Tree 1 DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1691 101972 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 150 Belvedere St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 3x3   5998294.0 2107899.0 37.767790508794896 -122.449193680863 (37.7677905087949, -122.449193680863) 15 5 11 29492 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 177.393ms · Data source: data.sfgov.org