Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
9386 | 9386 | 926 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6002807.701830001 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | |||
11074 | 11074 | 882 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.9739299999 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | ||
28427 | 28427 | 83251 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | |
33610 | 33610 | 84133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 23 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50705 | 6011012.12355 | 2088466.5124700002 | 37.7151523039101 | -122.403835398892 | (37.7151523039101, -122.403835398892) | |
42954 | 42954 | 79486 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | |
65265 | 65265 | 83279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.449010201 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | |
66946 | 66946 | 79951 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4332 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.749242657582705 | -122.50658364702 | (37.7492426575827, -122.50658364702) | |
69872 | 69872 | 50219 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2726 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2004 12:00:00 AM | 8 | 3x3 | Permit Number 46926 | 5987073.255969999 | 2111201.4718400002 | 37.776209992885 | -122.48824709613301 | (37.776209992885, -122.488247096133) |
70974 | 70974 | 121603 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 749 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6012453.25739 | 2104452.2107 | 37.7591260835233 | -122.399976111225 | (37.7591260835233, -122.399976111225) | |||
79594 | 79594 | 12917 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
81689 | 81689 | 57377 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3505 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006157.87748572 | 2102561.9990288 | 37.7535830045092 | -122.42161432346902 | (37.7535830045092, -122.421614323469) | ||
92356 | 92356 | 79056 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50038 | 5983215.17096299 | 2102463.12302331 | 37.7519911277095 | -122.500946646871 | (37.7519911277095, -122.500946646871) | ||
92847 | 92847 | 81868 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3012-3014 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52207 | 6009486.0303434 | 2101043.89087343 | 37.749601722793 | -122.40999763091601 | (37.749601722793, -122.409997630916) | ||
93184 | 93184 | 119281 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992077.0 | 2088275.0 | 37.713550438396396 | -122.469268843393 | (37.7135504383964, -122.469268843393) | ||||
93449 | 93449 | 56335 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 354 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777757 | 5987487.44856113 | 2113581.55129815 | 37.782769173736206 | -122.486989143207 | (37.7827691737362, -122.486989143207) | |
95135 | 95135 | 50288 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
95217 | 95217 | 50293 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
98542 | 98542 | 12918 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
99949 | 99949 | 82598 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3503 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006166.2666895995 | 2102562.46439955 | 37.7535847553547 | -122.42158534476499 | (37.7535847553547, -122.421585344765) | ||
100951 | 100951 | 50290 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
101609 | 101609 | 43632 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | ||
102346 | 102346 | 50292 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
107598 | 107598 | 82810 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.735965062583205 | -122.500898621502 | (37.7359650625832, -122.500898621502) | ||
109767 | 109767 | 47881 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1454 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50547 | 5982810.24276317 | 2105223.95269531 | 37.759547805419004 | -122.50255124802099 | (37.759547805419, -122.502551248021) | ||
115064 | 115064 | 105256 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185683998 | (37.7195776934466, -122.42687185684) | ||
121074 | 121074 | 117519 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
122500 | 122500 | 115975 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006168.0 | 2102576.0 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | |||
122974 | 122974 | 79279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2706 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50726 | 5983101.82229012 | 2096724.27729962 | 37.7362271801162 | -122.50091424264 | (37.7362271801162, -122.50091424264) | ||
126667 | 126667 | 50289 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
128843 | 128843 | 47111 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45095 | 6007076.38254046 | 2097931.15674799 | 37.740919506174706 | -122.41810964654499 | (37.7409195061747, -122.418109646545) |
138680 | 138680 | 36317 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51552 | 5996115.78800404 | 2094224.07875239 | 37.730117759471895 | -122.455739200241 | (37.7301177594719, -122.455739200241) | ||
142094 | 142094 | 109138 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773583 | 5985365.401319999 | 2110729.9835 | 37.7748156320332 | -122.49412018624099 | (37.7748156320332, -122.494120186241) |
143078 | 143078 | 121420 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1155x Prague St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6000780.0 | 2086820.0 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | ||||
143931 | 143931 | 82814 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2724 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50727 | 5983103.67908303 | 2096652.63979189 | 37.7360305919754 | -122.500902526777 | (37.7360305919754, -122.500902526777) | ||
145101 | 145101 | 50291 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
145200 | 145200 | 109133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773526 | 5985442.4 | 2110611.6 | 37.7744950899459 | -122.493845109753 | (37.7744950899459, -122.493845109753) |
163773 | 163773 | 83208 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3634 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50746 | 5981914.57527844 | 2100148.1004138 | 37.7455582728462 | -122.505272655065 | (37.7455582728462, -122.505272655065) | |
171269 | 171269 | 83239 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4332 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.749242657582705 | -122.50658364702 | (37.7492426575827, -122.50658364702) | |
172830 | 172830 | 84447 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.744321183805106 | -122.503635505549 | (37.7443211838051, -122.503635505549) | |
173767 | 173767 | 83228 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4234 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50748 | 5982916.47531802 | 2098139.9083931 | 37.740103232807705 | -122.50165975231 | (37.7401032328077, -122.50165975231) |
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");