Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24167 | 24167 | 229784 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1350 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010843.40414 | 2102039.00655 | 37.752410075071204 | -122.405373833155 | (37.7524100750712, -122.405373833155) | |||
24889 | 24889 | 229735 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1440 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009547.83815 | 2100777.83843 | 37.748874665647 | -122.409765119277 | (37.748874665647, -122.409765119277) | |||
27540 | 27540 | 68129 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301001 | (37.7581797826985, -122.39503416301) | |
28403 | 28403 | 226820 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004617.45608 | 2097657.55415 | 37.740029548214004 | -122.426592230667 | (37.740029548214, -122.426592230667) | |||
28823 | 28823 | 37988 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.39507287703199 | (37.7585156794839, -122.395072877032) | |
30186 | 30186 | 226343 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006735.41431 | 2102506.35586 | 37.7534627702098 | -122.41961312285 | (37.7534627702098, -122.41961312285) | |||
35104 | 35104 | 248002 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009958.97644 | 2098527.35445 | 37.742718361070004 | -122.408184696582 | (37.74271836107, -122.408184696582) | |||
40700 | 40700 | 226317 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1332 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007672.14775 | 2101889.27632 | 37.7518211306439 | -122.416329985835 | (37.7518211306439, -122.416329985835) | |||
43281 | 43281 | 229835 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2899 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010132.5344 | 2101618.9550900003 | 37.7512169355291 | -122.407802532369 | (37.7512169355291, -122.407802532369) | |||
53312 | 53312 | 229893 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008237.21282 | 2099854.8620700003 | 37.7462668439462 | -122.414231983545 | (37.7462668439462, -122.414231983545) | |||
53854 | 53854 | 228549 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009550.58062 | 2101412.53302 | 37.7506175499731 | -122.40980043116501 | (37.7506175499731, -122.409800431165) | |||
53882 | 53882 | 229866 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005094.82025 | 2098749.88858 | 37.7430558262652 | -122.42501940003099 | (37.7430558262652, -122.425019400031) | |||
56810 | 56810 | 226363 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 178 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006046.41496 | 2096344.0144900002 | 37.736503542996296 | -122.421558204449 | (37.7365035429963, -122.421558204449) | |||
63686 | 63686 | 32948 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.76231031129179 | -122.39834906047399 | (37.7623103112918, -122.398349060474) | ||
72376 | 72376 | 226769 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001809.15664 | 2102809.6039 | 37.7540166941382 | -122.4366708501 | (37.7540166941382, -122.4366708501) | |||
73729 | 73729 | 229870 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3952 26th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6004170.69747 | 2100746.77802 | 37.7484865785056 | -122.42835706113001 | (37.7484865785056, -122.42835706113) | |||
74299 | 74299 | 226455 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008017.57842 | 2104465.14642 | 37.7589133021322 | -122.4153177674 | (37.7589133021322, -122.4153177674) | |||
74614 | 74614 | 226387 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | |||
74959 | 74959 | 226390 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006633.7821 | 2097989.5025 | 37.741054788845204 | -122.41964413689101 | (37.7410547888452, -122.419644136891) | |||
80186 | 80186 | 104963 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3z3 | Permit Number 770948 | 6008023.0 | 2099506.0 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | ||
123722 | 123722 | 226789 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4432 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001262.11488 | 2104680.78699 | 37.759123406241606 | -122.438696718674 | (37.7591234062416, -122.438696718674) | |||
131723 | 131723 | 226342 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006734.79318 | 2102518.9123400003 | 37.7534972124365 | -122.41961616167299 | (37.7534972124365, -122.419616161673) | |||
132371 | 132371 | 226389 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | |||
132593 | 132593 | 229823 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 972 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6009935.37362 | 2103568.4929 | 37.7565588922846 | -122.40862185253599 | (37.7565588922846, -122.408621852536) | |||
144969 | 144969 | 226392 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.746027577510795 | -122.414955412565 | (37.7460275775108, -122.414955412565) | |||
148051 | 148051 | 226798 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3992 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003742.962230001 | 2104233.1900299997 | 37.7580352319537 | -122.430084836864 | (37.7580352319537, -122.430084836864) | |||
152131 | 152131 | 226403 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008209.691880001 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | |||
152613 | 152613 | 229890 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008246.22081 | 2099723.2099 | 37.7459058623841 | -122.414191522144 | (37.7459058623841, -122.414191522144) | |||
156354 | 156354 | 226452 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3070 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008472.25902 | 2102739.35181 | 37.7542002061943 | -122.413623200976 | (37.7542002061943, -122.413623200976) | |||
157355 | 157355 | 68190 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1625 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31967 | 6012798.25639 | 2105161.94327 | 37.761094081638 | -122.398832742859 | (37.761094081638, -122.398832742859) | ||
166291 | 166291 | 49831 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 547@ 20th S Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 9 | Permit Number 46614 | 6013570.32082 | 2104515.6666900003 | 37.7593625359769 | -122.396117192266 | (37.7593625359769, -122.396117192266) | |
166350 | 166350 | 72455 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 548 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 9 | 6010352.2868 | 2119601.9151 | 37.8006062535339 | -122.40831085027901 | (37.8006062535339, -122.408310850279) | ||
166406 | 166406 | 229808 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1801 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009536.40285 | 2106125.1164599997 | 37.7635564478901 | -122.410182137596 | (37.7635564478901, -122.410182137596) | |||
168371 | 168371 | 229745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6006000.19569 | 2099145.76871 | 37.7441939246187 | -122.42191696741699 | (37.7441939246187, -122.421916967417) | |||
170425 | 170425 | 226770 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001804.17577 | 2102825.14189 | 37.7540590746692 | -122.43668918726401 | (37.7540590746692, -122.436689187264) | |||
175875 | 175875 | 226809 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 85 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003890.70666 | 2106665.10208 | 37.7647210474575 | -122.42974732669201 | (37.7647210474575, -122.429747326692) | |||
180694 | 180694 | 229796 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005429.44821 | 2105495.57142 | 37.7615968062711 | -122.42434202886999 | (37.7615968062711, -122.42434202887) | |||
181787 | 181787 | 190728 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.768257686259105 | -122.406890823964 | (37.7682576862591, -122.406890823964) | |||
182453 | 182453 | 226778 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3934 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003366.66584 | 2105380.9002799997 | 37.761165250397 | -122.43146816144301 | (37.761165250397, -122.431468161443) | |||
186355 | 186355 | 39588 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.1192799998 | 37.7562633193119 | -122.40186376750601 | (37.7562633193119, -122.401863767506) | |
187007 | 187007 | 226411 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383516996 | -122.410548750743 | (37.741313383517, -122.410548750743) | |||
188639 | 188639 | 226373 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4222 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002349.444019999 | 2100642.72182 | 37.7480976397016 | -122.434647475301 | (37.7480976397016, -122.434647475301) |
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");