Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2580 | 2580 | 27387 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007153.30759 | 2119954.57165 | 37.8013949068162 | -122.419405682544 | (37.8013949068162, -122.419405682544) | |||
8152 | 8152 | 102822 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 347 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 20638 | 5999052.21165 | 2115387.8752099997 | 37.7883963685539 | -122.44711013813401 | (37.7883963685539, -122.447110138134) | ||
31087 | 31087 | 119029 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 767 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5982273.77271 | 2110527.62617 | 37.7740786267097 | -122.504799591882 | (37.7740786267097, -122.504799591882) | |||
33785 | 33785 | 129500 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2144 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002804.8844800005 | 2118207.36125 | 37.7963516481611 | -122.434328161126 | (37.7963516481611, -122.434328161126) | |||
34739 | 34739 | 129549 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.78954630017979 | -122.40205298038401 | (37.7895463001798, -122.402052980384) | |||
34884 | 34884 | 129516 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000442.909 | 2118797.59081 | 37.797837912738295 | -122.44254346802 | (37.7978379127383, -122.44254346802) | |||
37851 | 37851 | 226637 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1199 Capp St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6007225.3101699995 | 2100622.72822 | 37.7483183396245 | -122.417785447755 | (37.7483183396245, -122.417785447755) | |||
47134 | 47134 | 129521 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000122.02291 | 2120260.78291 | 37.8018371520253 | -122.443758994388 | (37.8018371520253, -122.443758994388) | |||
48699 | 48699 | 129547 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 13 Miller Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6010075.14286 | 2116919.1763 | 37.7932245849005 | -122.40908048339399 | (37.7932245849005, -122.409080483394) | |||
57229 | 57229 | 191425 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 798 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012697.8338 | 2103815.11788 | 37.757390399158794 | -122.399085525191 | (37.7573903991588, -122.399085525191) | |||
59980 | 59980 | 129511 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3223 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002767.09508 | 2119707.46883 | 37.8004684081385 | -122.43456623596799 | (37.8004684081385, -122.434566235968) | |||
64468 | 64468 | 191428 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 22 Robblee Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6012599.814780001 | 2095974.63355 | 37.735856643564404 | -122.39887425376001 | (37.7358566435644, -122.39887425376) | |||
66967 | 66967 | 129530 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1040 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6007879.71026 | 2119961.12323 | 37.8014537818135 | -122.416892463243 | (37.8014537818135, -122.416892463243) | |||
67745 | 67745 | 226648 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1488 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005200.770269999 | 2099715.54685 | 37.7457132878504 | -122.42472173433701 | (37.7457132878504, -122.424721734337) | |||
70389 | 70389 | 129503 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2656 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000257.59997 | 2118546.4747099997 | 37.797137849879896 | -122.44316664242099 | (37.7971378498799, -122.443166642421) | |||
73064 | 73064 | 123375 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 757 03rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5995016.33653 | 2110447.72713 | 37.7746006270727 | -122.460715372994 | (37.7746006270727, -122.460715372994) | ||||
101701 | 101701 | 112545 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 HIDALGO TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6004997.0 | 2107458.0 | 37.7669607387675 | -122.425977392818 | (37.7669607387675, -122.425977392818) | |||
130785 | 130785 | 129508 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1714 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004680.4249 | 2119161.32221 | 37.7990772585711 | -122.427906404578 | (37.7990772585711, -122.427906404578) | |||
131107 | 131107 | 129515 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2730 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999181.629430001 | 2118207.9413900003 | 37.7961469175038 | -122.44686537955 | (37.7961469175038, -122.44686537955) | |||
132877 | 132877 | 117693 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 435 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5982808.8484 | 2112817.53757 | 37.7803975176735 | -122.503118273577 | (37.7803975176735, -122.503118273577) | |||
144257 | 144257 | 226646 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 Hidalgo Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6004999.4002 | 2107477.2952799997 | 37.767013854632 | -122.425970464583 | (37.767013854632, -122.425970464583) | |||
148565 | 148565 | 129542 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 508 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010625.70171 | 2115928.16115 | 37.7905343223424 | -122.407105618041 | (37.7905343223424, -122.407105618041) | |||
150604 | 150604 | 177029 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 123 Seneca Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6000050.7624699995 | 2090072.63848 | 37.7189438978236 | -122.441837691751 | (37.7189438978236, -122.441837691751) | |||
157440 | 157440 | 129527 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006554.47344 | 2120382.0459 | 37.802534896425 | -122.421508295689 | (37.802534896425, -122.421508295689) | |||
161992 | 161992 | 129502 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2857 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 5999324.2861 | 2118011.40576 | 37.7956154316639 | -122.44635761511499 | (37.7956154316639, -122.446357615115) | |||
163344 | 163344 | 226643 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 48 Cumberland St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005334.035069999 | 2104616.89651 | 37.75917878378829 | -122.42460951781099 | (37.7591787837883, -122.424609517811) | |||
165011 | 165011 | 120188 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 224 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987762.7194300005 | 2114453.05727 | 37.785178126956396 | -122.486100829584 | (37.7851781269564, -122.486100829584) | |||
165862 | 165862 | 129518 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.797767715271796 | -122.44253092607 | (37.7977677152718, -122.44253092607) | |||
166827 | 166827 | 226658 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 117 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003646.084869999 | 2097679.68219 | 37.7400353434466 | -122.429952409889 | (37.7400353434466, -122.429952409889) | |||
169559 | 169559 | 191421 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 785 Rhode Island St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6011879.919919999 | 2104709.23521 | 37.7597998340098 | -122.40197706591002 | (37.7597998340098, -122.40197706591) | |||
170003 | 170003 | 123059 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 500 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991916.7341 | 2111968.89129 | 37.7785985076866 | -122.47154827826901 | (37.7785985076866, -122.471548278269) | |||
170738 | 170738 | 249913 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 356 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011242.070719999 | 2120420.51237 | 37.802903706599295 | -122.40528949653601 | (37.8029037065993, -122.405289496536) | |||
172460 | 172460 | 75304 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 2 | 6010043.764880001 | 2111144.47071 | 37.7773668617363 | -122.408781461497 | (37.7773668617363, -122.408781461497) | ||
178665 | 178665 | 177036 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 15 Merrill St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6009502.62349 | 2094943.7258099997 | 37.7328529276995 | -122.409509775682 | (37.7328529276995, -122.409509775682) | |||
180697 | 180697 | 129556 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 216 Post St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6011025.30596 | 2115257.2463 | 37.7887145046082 | -122.405675728365 | (37.7887145046082, -122.405675728365) | |||
182054 | 182054 | 129505 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2644 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000286.7796 | 2118548.8617700003 | 37.7971460678835 | -122.44306584551501 | (37.7971460678835, -122.443065845515) | |||
186716 | 186716 | 129538 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010716.07014 | 2115909.27019 | 37.7904875090489 | -122.406791615267 | (37.7904875090489, -122.406791615267) | |||
187883 | 187883 | 129522 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1240 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006403.02216 | 2120103.20622 | 37.8017607330441 | -122.422012573438 | (37.8017607330441, -122.422012573438) | |||
188033 | 188033 | 226640 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 10 Crescent Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6005282.96903 | 2095902.7994400002 | 37.7352489878562 | -122.42416639485799 | (37.7352489878562, -122.424166394858) |
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");