Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65053 | 65053 | 37086 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39686 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | |
| 127807 | 127807 | 40209 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 546 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41391 | 5982267.21985305 | 2112050.10759861 | 37.778258529647005 | -122.50493510260799 | (37.778258529647, -122.504935102608) | ||
| 32571 | 32571 | 69145 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | |
| 114669 | 114669 | 53682 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30735 | 5984157.5341821 | 2109855.55736393 | 37.7723439568609 | -122.49823378959 | (37.7723439568609, -122.49823378959) | ||
| 64061 | 64061 | 32346 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 78102 | 78102 | 32344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 107835 | 107835 | 32345 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 135969 | 135969 | 32347 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.764498837803394 | -122.494459352499 | (37.7644988378034, -122.494459352499) | |
| 154995 | 154995 | 32348 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.49445591941799 | (37.764529258945, -122.494455919418) | |
| 34587 | 34587 | 78000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2000 12:00:00 AM | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | ||
| 44369 | 44369 | 42898 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2060 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 7 | Permit Number 45580 | 5986523.9754 | 2097068.6969 | 37.737373201510295 | -122.489107923346 | (37.7373732015103, -122.489107923346) | |
| 74936 | 74936 | 42897 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | |
| 147832 | 147832 | 42896 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42813 | 5986675.0189 | 2096952.6028 | 37.737063252741706 | -122.488577172427 | (37.7370632527417, -122.488577172427) | |
| 118633 | 118633 | 69308 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | Permit Number 33387 | 5986864.5682116 | 2104707.11140573 | 37.7583661086574 | -122.488491577304 | (37.7583661086574, -122.488491577304) | ||
| 88063 | 88063 | 33257 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | ||
| 58356 | 58356 | 71805 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5987333.5642 | 2098599.3879 | 37.741623296224205 | -122.486421183565 | (37.7416232962242, -122.486421183565) | ||
| 44871 | 44871 | 36124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | |
| 10474 | 10474 | 34625 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) |
| 173732 | 173732 | 34626 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.220433701 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | |
| 145457 | 145457 | 67397 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 615 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | Permit Number 30894 | 5990626.25534689 | 2111189.00376145 | 37.776382409214705 | -122.47595552081499 | (37.7763824092147, -122.475955520815) | ||
| 154629 | 154629 | 113718 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991385.6612 | 2110673.31757 | 37.7750104780928 | -122.473290929077 | (37.7750104780928, -122.473290929077) | |||
| 55462 | 55462 | 113717 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991400.52029 | 2110673.00421 | 37.775010478076794 | -122.47323950591299 | (37.7750104780768, -122.473239505913) | |||
| 38779 | 38779 | 68329 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 12 | Permit Number 32144 | 5991421.402000001 | 2110674.853 | 37.7750167634254 | -122.47316740712401 | (37.7750167634254, -122.473167407124) | |
| 105423 | 105423 | 41830 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1232 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2001 12:00:00 AM | Permit Number 42216 | 5991454.19182704 | 2107029.2184828 | 37.765008732916705 | -122.472788101582 | (37.7650087329167, -122.472788101582) | ||
| 120261 | 120261 | 45313 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 359 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44150 | 5991933.83383604 | 2090925.21902291 | 37.7208190204058 | -122.46995651824301 | (37.7208190204058, -122.469956518243) | ||
| 97815 | 97815 | 67367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30860 | 5991947.66141854 | 2111184.68459598 | 37.7764470789457 | -122.47138413483101 | (37.7764470789457, -122.471384134831) | ||
| 107001 | 107001 | 43661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 370 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43304 | 5992506.56767844 | 2112958.60482073 | 37.781350097045 | -122.46957990283 | (37.781350097045, -122.46957990283) | ||
| 119059 | 119059 | 47172 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 310 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45136 | 5992595.84229454 | 2094810.68405906 | 37.731525796784 | -122.46795064653 | (37.731525796784, -122.46795064653) | ||
| 125998 | 125998 | 33399 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 300 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37517 | 5992600.35501271 | 2094892.48894855 | 37.7317506732587 | -122.467940993296 | (37.7317506732587, -122.467940993296) | ||
| 106159 | 106159 | 64173 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 30 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | Permit Number 24955 | 5992735.52734942 | 2093091.96966529 | 37.7268146975842 | -122.467342804105 | (37.7268146975842, -122.467342804105) | ||
| 94512 | 94512 | 37474 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | ||
| 104133 | 104133 | 64176 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.727002217924706 | -122.466730800624 | (37.7270022179247, -122.466730800624) | ||
| 96828 | 96828 | 68073 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31811 | 5993016.05828809 | 2103198.83445662 | 37.7545817907356 | -122.46710752853501 | (37.7545817907356, -122.467107528535) | ||
| 89405 | 89405 | 31180 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 344 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34878 | 5993129.55455829 | 2089868.58886975 | 37.717986817508 | -122.465746580217 | (37.717986817508, -122.465746580217) | ||
| 101981 | 101981 | 41993 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.46447296226299 | (37.7278059137082, -122.464472962263) | ||
| 126861 | 126861 | 33356 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37493 | 5994058.57591139 | 2093537.34847989 | 37.7281138896418 | -122.46280139081699 | (37.7281138896418, -122.462801390817) | ||
| 42992 | 42992 | 32891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 128285 | 128285 | 32890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 101308 | 101308 | 43731 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | ||
| 135030 | 135030 | 75408 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994441.08765 | 2086786.6315099997 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | ||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
| 109135 | 109135 | 67746 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1479 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31365 | 5994572.72013397 | 2105470.39847949 | 37.7609086531136 | -122.461888924556 | (37.7609086531136, -122.461888924556) | ||
| 81990 | 81990 | 43708 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 103294 | 103294 | 43707 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 144602 | 144602 | 43706 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 101869 | 101869 | 66237 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.72010089980329 | -122.45740432201 | (37.7201008998033, -122.45740432201) | ||
| 79951 | 79951 | 32740 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | ||
| 96226 | 96226 | 32739 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.45718507236099 | (37.7148491391882, -122.457185072361) | ||
| 84092 | 84092 | 30931 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | ||
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 118826 | 118826 | 33189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 123758 | 123758 | 33190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 103621 | 103621 | 33192 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 53 Idora Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37399 | 5996322.19797653 | 2099597.08028102 | 37.7448825563847 | -122.455413791656 | (37.7448825563847, -122.455413791656) | ||
| 85817 | 85817 | 45250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.188004401 | 2098465.43898756 | 37.7417803963921 | -122.45502778464599 | (37.7417803963921, -122.455027784646) | ||
| 87509 | 87509 | 66256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | ||
| 61126 | 61126 | 50520 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | |
| 80747 | 80747 | 68174 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 449 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/01/1995 12:00:00 AM | Permit Number 31945 | 5997091.52876923 | 2111801.84543591 | 37.778437859612005 | -122.45363471008001 | (37.778437859612, -122.45363471008) | ||
| 101299 | 101299 | 39622 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 109830 | 109830 | 39623 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 82740 | 82740 | 67907 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 557 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 31610 | 5997734.62104287 | 2094370.88558597 | 37.7306136268107 | -122.450153291964 | (37.7306136268107, -122.450153291964) | ||
| 113622 | 113622 | 41148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | ||
| 108121 | 108121 | 42339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42544 | 5997882.68725291 | 2094126.21532195 | 37.7299502922476 | -122.449623783134 | (37.7299502922476, -122.449623783134) | ||
| 123798 | 123798 | 67185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.76087342528071 | -122.44976537124599 | (37.7608734252807, -122.449765371246) | |
| 96633 | 96633 | 42373 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 116996 | 116996 | 42372 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 127159 | 127159 | 39701 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | ||
| 108082 | 108082 | 39702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2004 12:00:00 AM | Permit Number 41087 | 5998596.38137062 | 2094778.55233682 | 37.731782260395 | -122.447203397318 | (37.731782260395, -122.447203397318) | ||
| 18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
| 75943 | 75943 | 44033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | |
| 24164 | 24164 | 54840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 236 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 6 | 3x3 | Permit Number 10695 | 5998822.5685 | 2109866.5256 | 37.77322305193879 | -122.447507074191 | (37.7732230519388, -122.447507074191) |
| 155339 | 155339 | 31136 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 371 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34851 | 5998968.1475599995 | 2094360.3261099998 | 37.730655144717105 | -122.445888061981 | (37.7306551447171, -122.445888061981) | |
| 143846 | 143846 | 67906 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 351 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31609 | 5999092.51556245 | 2094349.39726639 | 37.7306322373229 | -122.44545731887 | (37.7306322373229, -122.44545731887) | ||
| 95424 | 95424 | 42113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 105527 | 105527 | 42114 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 81910 | 81910 | 42335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 91322 | 91322 | 42334 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 78530 | 78530 | 42106 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 145378 | 145378 | 42099 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42405 | 5999399.61952202 | 2094185.90721086 | 37.730200858866205 | -122.44438387280898 | (37.7302008588662, -122.444383872809) | ||
| 83688 | 83688 | 42111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 90886 | 90886 | 42110 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 102717 | 102717 | 42112 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 95514 | 95514 | 63606 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 717 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | Permit Number 24243 | 5999597.4131629 | 2110926.64814812 | 37.7761781281102 | -122.444903013727 | (37.7761781281102, -122.444903013727) | ||
| 122870 | 122870 | 61325 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 750 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1984 12:00:00 AM | Permit Number 21228 | 5999633.66350661 | 2111045.76132591 | 37.77650725122871 | -122.44478617828301 | (37.7765072512287, -122.444786178283) | ||
| 108915 | 108915 | 66907 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 541 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1992 12:00:00 AM | Permit Number 30285 | 5999680.75570363 | 2110323.09068481 | 37.7745256692579 | -122.44457132109301 | (37.7745256692579, -122.444571321093) | ||
| 108511 | 108511 | 57975 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2602 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | Permit Number 20908 | 5999705.92548521 | 2113681.4260983 | 37.783748232079894 | -122.444725695659 | (37.7837482320799, -122.444725695659) | ||
| 137990 | 137990 | 70572 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 421 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 10 | 5999717.91 | 2110099.0732 | 37.773912694204 | -122.44442669475401 | (37.773912694204, -122.444426694754) | ||
| 156125 | 156125 | 38044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.785581471348706 | -122.443435225951 | (37.7855814713487, -122.443435225951) | |
| 30607 | 30607 | 38043 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.44341765838199 | (37.7855000811005, -122.443417658382) | |
| 150176 | 150176 | 38055 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.78573152849079 | -122.442968502827 | (37.7857315284908, -122.442968502827) | |
| 69451 | 69451 | 38054 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/01/1999 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | |
| 64628 | 64628 | 71308 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.44271758887699 | (37.7781096083019, -122.442717588877) | ||
| 149284 | 149284 | 64511 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 833 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 11 | Permit Number 25392 | 6000435.9873 | 2111865.4379 | 37.7788036283278 | -122.442069568781 | (37.7788036283278, -122.442069568781) | |
| 185639 | 185639 | 40169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1901 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | 0 | Permit Number 41362 | 6000480.4385885 | 2111652.95524414 | 37.7782227381789 | -122.44190053998399 | (37.7782227381789, -122.441900539984) | |
| 137659 | 137659 | 64510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 838 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 12 | Permit Number 25391 | 6000497.2416 | 2111874.2369 | 37.778831278686496 | -122.441858298358 | (37.7788312786865, -122.441858298358) | |
| 94027 | 94027 | 64512 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25393 | 6000501.90082075 | 2111793.8331913003 | 37.7786107760856 | -122.441836408094 | (37.7786107760856, -122.441836408094) | ||
| 168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
| 176862 | 176862 | 38050 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.786021340576205 | -122.441934174319 | (37.7860213405762, -122.441934174319) | |
| 27735 | 27735 | 38051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875696997 | 37.786031962456896 | -122.44178988005899 | (37.7860319624569, -122.441789880059) | |
| 141216 | 141216 | 65182 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 49 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27166 | 6000612.59181755 | 2102724.86163023 | 37.7537159395855 | -122.44080276840201 | (37.7537159395855, -122.440802768402) |
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");