Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21042 | 21042 | 2393 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2656 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2002 12:00:00 AM | 8 | 3X3 | 6009747.5539 | 2101876.46868 | 37.7519024509371 | -122.409152011861 | (37.7519024509371, -122.409152011861) | ||
| 18647 | 18647 | 5527 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 882 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6005005.94295 | 2103241.13664 | 37.7553827355522 | -122.425646301253 | (37.7553827355522, -122.425646301253) | |||
| 20285 | 20285 | 10083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | ||
| 20507 | 20507 | 10084 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | ||
| 21627 | 21627 | 10139 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.7160799997 | 37.7566603214356 | -122.42320418503999 | (37.7566603214356, -122.42320418504) | ||
| 13280 | 13280 | 10220 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | |||
| 13609 | 13609 | 12227 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.735913201034606 | -122.387848277235 | (37.7359132010346, -122.387848277235) | ||
| 9605 | 9605 | 17889 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | ||
| 17784 | 17784 | 18386 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 816 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/1997 12:00:00 AM | 12 | 3X3 | 6010411.4798 | 2104364.47697 | 37.7587711399879 | -122.407031402383 | (37.7587711399879, -122.407031402383) | ||
| 9759 | 9759 | 24293 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 302 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 2x2 | 6006647.73618 | 2098006.46065 | 37.741102138158 | -122.41959709154101 | (37.741102138158, -122.419597091541) | ||
| 20051 | 20051 | 26498 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008903.18819 | 2102577.2710700002 | 37.7537793576317 | -122.412121481544 | (37.7537793576317, -122.412121481544) | ||
| 20704 | 20704 | 26501 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2752 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6008910.69527 | 2102429.93481 | 37.7533752266066 | -122.41208510844801 | (37.7533752266066, -122.412085108448) | |||
| 14097 | 14097 | 27140 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011410.17472 | 2095355.19259 | 37.7340894298873 | -122.40294377776002 | (37.7340894298873, -122.40294377776) | |||
| 13611 | 13611 | 27142 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011388.172669999 | 2095338.5375299999 | 37.7340424699754 | -122.40301867507401 | (37.7340424699754, -122.403018675074) | |||
| 21333 | 21333 | 28065 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2576 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2001 12:00:00 AM | 12 | 3X3 | 6009719.0461099995 | 2102350.04498 | 37.753201188885605 | -122.409284012572 | (37.7532011888856, -122.409284012572) | ||
| 92025 | 92025 | 28275 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 6 | 2X3 | 6006647.725204401 | 2098034.3646343 | 37.7411787556411 | -122.419599108791 | (37.7411787556411, -122.419599108791) | ||
| 120910 | 120910 | 29076 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2299X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009690.9471404 | 2103965.2718708 | 37.7576346655719 | -122.409495172566 | (37.7576346655719, -122.409495172566) | ||
| 310 | 310 | 30658 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.417719999 | 2109608.9608 | 37.7730122661246 | -122.41720454865299 | (37.7730122661246, -122.417204548653) |
| 184158 | 184158 | 30882 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 601 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 6 | Permit Number 48128 | 6014140.03931 | 2104332.5507 | 37.7588914216105 | -122.39413399288601 | (37.7588914216105, -122.394133992886) | ||
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 134683 | 134683 | 32942 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 13 | Permit Number 37261 | 6015289.11919 | 2103969.2804799997 | 37.757957759865604 | -122.39013452698299 | (37.7579577598656, -122.390134526983) | |
| 14778 | 14778 | 32943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.39014514528499 | (37.7581508424957, -122.390145145285) |
| 96840 | 96840 | 32944 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37262 | 6012923.17595221 | 2106002.78448692 | 37.7634098055879 | -122.398459699211 | (37.7634098055879, -122.398459699211) | |||
| 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) | ||
| 14393 | 14393 | 32960 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 934 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 16 | 6x12 | Permit Number 37274 | 6015218.03519 | 2104239.88822 | 37.7586968478982 | -122.390399274809 | (37.7586968478982, -122.390399274809) |
| 16487 | 16487 | 32962 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 952 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | 6x12 | Permit Number 37276 | 6015219.88415 | 2104168.1362900003 | 37.7584999350397 | -122.39038786691299 | (37.7584999350397, -122.390387866913) |
| 158910 | 158910 | 32965 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 550 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 11 | 7x6 | Permit Number 37280 | 6014071.41137 | 2104533.66356 | 37.7594398192185 | -122.394385423553 | (37.7594398192185, -122.394385423553) |
| 156251 | 156251 | 32967 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 571 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | Permit Number 37282 | 6014131.46964 | 2104484.11535 | 37.7593071089655 | -122.394174242052 | (37.7593071089655, -122.394174242052) | |
| 25065 | 25065 | 32969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 580 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37284 | 6014077.45388 | 2104409.80131 | 37.759100056248606 | -122.39435585294399 | (37.7591000562486, -122.394355852944) | |
| 30560 | 30560 | 32977 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 448 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 4 | Permit Number 46744 | 6014321.91414 | 2105021.23892 | 37.76079251737271 | -122.393553179256 | (37.7607925173727, -122.393553179256) | |
| 70237 | 70237 | 32980 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.0613700002 | 37.7593873374867 | -122.39515493295201 | (37.7593873374867, -122.395154932952) | |
| 38020 | 38020 | 32982 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 559 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37295 | 6013853.095 | 2104468.98134 | 37.7592500775456 | -122.39513594376899 | (37.7592500775456, -122.395135943769) | |
| 120144 | 120144 | 33026 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3428 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.931002299 | 2100900.56738488 | 37.7490622873512 | -122.41896834404699 | (37.7490622873512, -122.418968344047) | ||
| 110445 | 110445 | 33027 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3428 26th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.931002299 | 2100900.56738488 | 37.7490622873512 | -122.41896834404699 | (37.7490622873512, -122.418968344047) | ||
| 101330 | 101330 | 33028 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3428 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.931002299 | 2100900.56738488 | 37.7490622873512 | -122.41896834404699 | (37.7490622873512, -122.418968344047) | ||
| 125330 | 125330 | 33029 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3428 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.931002299 | 2100900.56738488 | 37.7490622873512 | -122.41896834404699 | (37.7490622873512, -122.418968344047) | ||
| 127170 | 127170 | 33030 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3428 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.931002299 | 2100900.56738488 | 37.7490622873512 | -122.41896834404699 | (37.7490622873512, -122.418968344047) | ||
| 141493 | 141493 | 33040 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37317 | 6005440.04608192 | 2101847.29088497 | 37.751580078433 | -122.42404592247 | (37.751580078433, -122.42404592247) | ||
| 96350 | 96350 | 33044 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 417 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37321 | 6005524.82070863 | 2101276.46802426 | 37.7500175164074 | -122.423712178429 | (37.7500175164074, -122.423712178429) | ||
| 95254 | 95254 | 33045 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 435 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | Permit Number 37322 | 6005530.37891091 | 2101176.15171839 | 37.749742384670796 | -122.423685826158 | (37.7497423846708, -122.423685826158) | ||
| 107124 | 107124 | 33046 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 444 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.749578703881895 | -122.42385052411699 | (37.7495787038819, -122.423850524117) | ||
| 142402 | 142402 | 33047 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.749578703881895 | -122.42385052411699 | (37.7495787038819, -122.423850524117) | ||
| 128583 | 128583 | 34056 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | ||
| 123352 | 123352 | 34057 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | ||
| 9458 | 9458 | 34058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37960 | |||||||||
| 78165 | 78165 | 34059 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | 12 | 6x7 | Permit Number 37961 | 6009447.37701969 | 2106694.23265708 | 37.7651141201322 | -122.410530241296 | (37.7651141201322, -122.410530241296) | |
| 106036 | 106036 | 34060 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1744 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 3x3 | Permit Number 37962 | 6009449.36433284 | 2106657.97750104 | 37.7650146832031 | -122.41052080730101 | (37.7650146832031, -122.410520807301) | |
| 101573 | 101573 | 34194 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 62 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | Permit Number 38013 | 6005507.05529052 | 2099654.01670417 | 37.7455616340181 | -122.42365827055599 | (37.7455616340181, -122.423658270556) | |||
| 97123 | 97123 | 34305 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38093 | 6010822.82923264 | 2102485.1673323996 | 37.7536339837486 | -122.40547640422199 | (37.7536339837486, -122.405476404222) | ||
| 95285 | 95285 | 34307 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 123693 | 123693 | 34308 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 125334 | 125334 | 34309 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 143681 | 143681 | 34310 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 103871 | 103871 | 34311 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 89554 | 89554 | 34312 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 100479 | 100479 | 34313 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 84473 | 84473 | 34314 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 120587 | 120587 | 34315 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 120370 | 120370 | 34316 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 111513 | 111513 | 34317 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 96982 | 96982 | 34318 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 82875 | 82875 | 34319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 82566 | 82566 | 34320 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 99217 | 99217 | 34321 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 122063 | 122063 | 34322 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 145262 | 145262 | 34323 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 114934 | 114934 | 34324 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 123214 | 123214 | 34325 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 97685 | 97685 | 34326 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 85813 | 85813 | 34327 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 142063 | 142063 | 34328 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 124842 | 124842 | 34329 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 138330 | 138330 | 34330 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 111061 | 111061 | 34331 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 143487 | 143487 | 34332 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 121018 | 121018 | 34333 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 120485 | 120485 | 34334 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 101333 | 101333 | 34335 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 19620 | 19620 | 34336 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 114212 | 114212 | 34337 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 87912 | 87912 | 34338 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 139198 | 139198 | 34366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | ||
| 107952 | 107952 | 34378 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38129 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | ||
| 81099 | 81099 | 34556 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.741319296524296 | -122.410459272722 | (37.7413192965243, -122.410459272722) | ||
| 121171 | 121171 | 34557 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Nebraska St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.741319296524296 | -122.410459272722 | (37.7413192965243, -122.410459272722) | ||
| 144518 | 144518 | 34728 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | ||
| 105035 | 105035 | 34729 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3171 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | ||
| 120966 | 120966 | 34730 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | |||
| 121374 | 121374 | 34731 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | |||
| 115332 | 115332 | 34732 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | |||
| 107136 | 107136 | 34733 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | |||
| 112955 | 112955 | 34734 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38384 | 6008507.54779719 | 2101522.76910569 | 37.7508617255783 | -122.413415130751 | (37.7508617255783, -122.413415130751) | ||
| 77618 | 77618 | 34735 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38385 | 6008060.11038004 | 2101550.08300487 | 37.7509115908716 | -122.41496434851001 | (37.7509115908716, -122.41496434851) | ||
| 99361 | 99361 | 34741 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2901 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.750860098121706 | -122.413831454694 | (37.7508600981217, -122.413831454694) | ||
| 88849 | 88849 | 34742 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2901 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.750860098121706 | -122.413831454694 | (37.7508600981217, -122.413831454694) | ||
| 100014 | 100014 | 34743 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2901 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.750860098121706 | -122.413831454694 | (37.7508600981217, -122.413831454694) | ||
| 144798 | 144798 | 34745 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2531 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38393 | 6008900.83649709 | 2103723.81151617 | 37.756927366913 | -122.41221064209999 | (37.756927366913, -122.4122106421) | ||
| 95568 | 95568 | 34746 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2633 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38394 | 6008932.99171324 | 2103129.73681544 | 37.7552979763123 | -122.41205745427901 | (37.7552979763123, -122.412057454279) | ||
| 97228 | 97228 | 34748 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2752 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 1 | 5x12 | Permit Number 38396 | 6008918.26554882 | 2102430.84513518 | 37.7533781509064 | -122.412058993069 | (37.7533781509064, -122.412058993069) |
| 124507 | 124507 | 34752 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 667 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2000 12:00:00 AM | Permit Number 38399 | 6007930.97034241 | 2104052.78354238 | 37.7577761801817 | -122.415588103657 | (37.7577761801817, -122.415588103657) |
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");