trees
85 rows where Fire Prevention Districts = 2 and qSpecies_id = 43 sorted by qLegalStatus_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3986 | 116680 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
37916 | 233997 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1027 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001336.17311 | 2100800.0445 | 37.7484720346532 | -122.438162590655 | (37.7484720346532, -122.438162590655) | 2 | 4 | 5 | 28862 | 22 | |||
75154 | 23668 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 315 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | 2 | 7 | 7 | 28859 | 2 | |||
41386 | 121194 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 255x Red Rock Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
3049 | 43998 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43555 | 6008950.71046834 | 2099077.83692872 | 37.7441733566649 | -122.411709892219 | (37.7441733566649, -122.411709892219) | 2 | 7 | 7 | 28859 | 2 | |||
3336 | 35927 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 22 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39097 | 6005564.10753047 | 2097077.73566378 | 37.738490969573 | -122.423277889221 | (37.738490969573, -122.423277889221) | 2 | 7 | 7 | 28859 | 2 | ||
3588 | 37560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 39999 | 6000466.36495931 | 2104620.54811441 | 37.758912703603 | -122.44144447135 | (37.758912703603, -122.44144447135) | 2 | 4 | 5 | 28862 | 38 | ||
10411 | 47385 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.7467954887327 | -122.437975585037 | (37.7467954887327, -122.437975585037) | 2 | 4 | 5 | 63 | 22 | |||
13812 | 34364 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1862 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38120 | 6004563.40220029 | 2097868.81083057 | 37.7406065549579 | -122.426794167737 | (37.7406065549579, -122.426794167737) | 2 | 7 | 5 | 63 | 7 | ||
14374 | 34363 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1846 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38119 | 6004556.0268692 | 2098000.12862747 | 37.7409667067108 | -122.426829018524 | (37.7409667067108, -122.426829018524) | 2 | 7 | 5 | 63 | 7 | ||
14912 | 34353 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.7418508681298 | -122.425694266568 | (37.7418508681298, -122.425694266568) | 2 | 7 | 5 | 63 | 7 | ||
18989 | 37041 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
19915 | 37424 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
20564 | 35401 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 527 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38856 | 6003213.78352736 | 2098311.09733417 | 37.7417445720019 | -122.431492193982 | (37.7417445720019, -122.431492193982) | 2 | 7 | 5 | 63 | 7 | ||
20587 | 40463 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 378 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41548 | 6007684.60346868 | 2097335.44684482 | 37.7393180333935 | -122.415964462581 | (37.7393180333935, -122.415964462581) | 2 | 7 | 7 | 28859 | 2 | ||
21691 | 35960 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 555 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39118 | 6006291.48461818 | 2096239.28811556 | 37.7362298031477 | -122.420703460764 | (37.7362298031477, -122.420703460764) | 2 | 7 | 7 | 28859 | 2 | ||
26194 | 34414 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 205 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38161 | 6004190.49432582 | 2097526.98545022 | 37.7396468892769 | -122.428059186764 | (37.7396468892769, -122.428059186764) | 2 | 7 | 5 | 63 | 7 | ||
29030 | 37044 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
29221 | 34402 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 160 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38149 | 6002458.41825324 | 2097080.12272084 | 37.7383217597979 | -122.434016021054 | (37.7383217597979, -122.434016021054) | 2 | 7 | 5 | 63 | 7 | ||
32928 | 37704 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
36633 | 35970 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 190 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39128 | 6006126.55379065 | 2096333.04753419 | 37.7364779485792 | -122.421280351482 | (37.7364779485792, -122.421280351482) | 2 | 7 | 7 | 28859 | 2 | ||
36835 | 37313 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
37192 | 35942 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 21 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39105 | 6007225.31509594 | 2097693.4445482 | 37.7402751828319 | -122.417577847872 | (37.7402751828319, -122.417577847872) | 2 | 7 | 7 | 28859 | 2 | ||
42365 | 39173 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 7461 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.417196465004 | (37.7612079095392, -122.417196465004) | 2 | 4 | 7 | 28859 | 19 | ||
42461 | 35961 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 555 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39118 | 6006291.48461818 | 2096239.28811556 | 37.7362298031477 | -122.420703460764 | (37.7362298031477, -122.420703460764) | 2 | 7 | 7 | 28859 | 2 | ||
44466 | 37043 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
45134 | 34388 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38136 | 6003730.56187145 | 2096520.40051304 | 37.7368570045518 | -122.429577666227 | (37.7368570045518, -122.429577666227) | 2 | 7 | 5 | 63 | 7 | ||
50923 | 34400 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 156 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38147 | 6002471.83146577 | 2097061.86671715 | 37.738272394243 | -122.433968340214 | (37.738272394243, -122.433968340214) | 2 | 7 | 5 | 63 | 7 | ||
63600 | 34404 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38152 | 6002491.04646095 | 2096956.56807226 | 37.7379843589135 | -122.433894379886 | (37.7379843589135, -122.433894379886) | 2 | 7 | 5 | 63 | 7 | ||
67437 | 36510 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 406 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39387 | 6007487.22983868 | 2096928.20854387 | 37.7381887481689 | -122.416618053798 | (37.7381887481689, -122.416618053798) | 2 | 7 | 7 | 28859 | 2 | ||
72751 | 37286 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | 2 | 4 | 5 | 28862 | 3 | ||
79486 | 37707 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
80984 | 36908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.436843078117 | (37.7560694803843, -122.436843078117) | 2 | 4 | 5 | 28862 | 3 | ||
86212 | 43997 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43554 | 6008915.83516029 | 2099075.89728061 | 37.7441660743482 | -122.411830346827 | (37.7441660743482, -122.411830346827) | 2 | 7 | 7 | 28859 | 2 | |||
87797 | 39174 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 7461 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.417196465004 | (37.7612079095392, -122.417196465004) | 2 | 4 | 7 | 28859 | 19 | ||
88126 | 43999 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 158 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43556 | 6009020.46100461 | 2099081.71622052 | 37.7441879209123 | -122.411468983209 | (37.7441879209123, -122.411468983209) | 2 | 7 | 7 | 28859 | 2 | |||
89415 | 40641 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.7443706801351 | -122.410814978675 | (37.7443706801351, -122.410814978675) | 2 | 7 | 7 | 28859 | 2 | |||
94256 | 34355 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.7401809675376 | -122.425706834494 | (37.7401809675376, -122.425706834494) | 2 | 7 | 5 | 63 | 7 | ||
96433 | 37701 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
98168 | 37716 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 943 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40086 | 6007607.04837726 | 2104169.37424002 | 37.7580780981898 | -122.416716622543 | (37.7580780981898, -122.416716622543) | 2 | 4 | 7 | 28859 | 19 | ||
100434 | 37455 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 125 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | 2 | 7 | 7 | 28859 | 2 | ||
105045 | 37437 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39912 | 6010454.2114909 | 2099614.59600709 | 37.745731407921 | -122.406548905427 | (37.745731407921, -122.406548905427) | 2 | 7 | 7 | 28859 | 2 | ||
110816 | 37426 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
114946 | 35548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38924 | 6005398.06539258 | 2103564.19233402 | 37.7562919206066 | -122.424313197508 | (37.7562919206066, -122.424313197508) | 2 | 4 | 5 | 28859 | 19 | ||
115816 | 67467 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 30982 | 6003350.50488606 | 2101289.69360575 | 37.7499308522406 | -122.431232018452 | (37.7499308522406, -122.431232018452) | 2 | 4 | 5 | 28862 | 22 | ||
122187 | 35402 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 531 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38857 | 6003188.18562105 | 2098310.25744294 | 37.7417408149917 | -122.431580643052 | (37.7417408149917, -122.431580643052) | 2 | 7 | 5 | 63 | 7 | ||
124119 | 37706 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
125415 | 34401 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38148 | 6002541.2507672 | 2096900.64630627 | 37.7378336595187 | -122.433716803341 | (37.7378336595187, -122.433716803341) | 2 | 7 | 5 | 63 | 7 | ||
125708 | 37427 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
126210 | 37454 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 125 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | 2 | 7 | 7 | 28859 | 2 | ||
126442 | 35941 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39104 | 6007226.10455525 | 2097703.31078326 | 37.7403023177454 | -122.417575817322 | (37.7403023177454, -122.417575817322) | 2 | 7 | 7 | 28859 | 2 | ||
126600 | 37423 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
127677 | 37042 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
128039 | 37702 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
131612 | 37420 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39898 | 6002152.44125634 | 2099703.71933952 | 37.7455081743626 | -122.435261547297 | (37.7455081743626, -122.435261547297) | 2 | 7 | 5 | 63 | 22 | ||
136510 | 34429 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38173 | 6002089.34387418 | 2096139.54747106 | 37.7357182050796 | -122.435224839434 | (37.7357182050796, -122.435224839434) | 2 | 7 | 5 | 63 | 7 | ||
137219 | 35519 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 90 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38920 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
140614 | 37066 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 326 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 39668 | 6003784.55345185 | 2099265.25748104 | 37.7443968092105 | -122.429586694845 | (37.7443968092105, -122.429586694845) | 2 | 7 | 5 | 63 | 22 | ||
142202 | 34398 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | 2 | 7 | 5 | 63 | 7 | |
142418 | 37039 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
142598 | 35422 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 527 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38873 | 6002518.46166442 | 2099137.02773671 | 37.7439729506581 | -122.433955407599 | (37.7439729506581, -122.433955407599) | 2 | 7 | 5 | 63 | 22 | ||
142691 | 36568 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 327 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39430 | 6006720.99763739 | 2096073.95090972 | 37.7358000222337 | -122.419206729617 | (37.7358000222337, -122.419206729617) | 2 | 7 | 7 | 28859 | 2 | ||
148447 | 35550 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 50 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.424455886685 | (37.7558983622011, -122.424455886685) | 2 | 4 | 5 | 28859 | 19 | ||
151337 | 36907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.7533966824522 | -122.440506941015 | (37.7533966824522, -122.440506941015) | 2 | 4 | 5 | 28862 | 22 | ||
154775 | 37314 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
155234 | 39134 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.7536958179011 | -122.417576944272 | (37.7536958179011, -122.417576944272) | 2 | 4 | 7 | 28859 | 19 | ||
159010 | 37040 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
161378 | 34346 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 255 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38104 | 6004828.12803067 | 2098393.70147146 | 37.7420627492496 | -122.425916201102 | (37.7420627492496, -122.425916201102) | 2 | 7 | 5 | 63 | 7 | ||
163982 | 35510 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3478 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38912 | 6005194.49677521 | 2103146.93967049 | 37.7551347452856 | -122.424987522768 | (37.7551347452856, -122.424987522768) | 2 | 4 | 5 | 28859 | 19 | ||
165109 | 39139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
166564 | 37709 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
168179 | 37708 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
168287 | 39138 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
168308 | 37063 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1468 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39664 | 6003912.84552522 | 2099719.17052238 | 37.7456504127787 | -122.429175446828 | (37.7456504127787, -122.429175446828) | 2 | 7 | 5 | 63 | 22 | ||
168833 | 37703 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
169743 | 37845 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.7446070428057 | -122.40707146066 | (37.7446070428057, -122.40707146066) | 2 | 7 | 7 | 28859 | 2 | ||
170691 | 37458 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.7989409 | 2099791.60340169 | 37.7462091274065 | -122.407074571233 | (37.7462091274065, -122.407074571233) | 2 | 7 | 7 | 28859 | 2 | ||
172670 | 39490 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4054 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40948 | 6002823.01095214 | 2101848.4791437 | 37.7514352381886 | -122.433096036215 | (37.7514352381886, -122.433096036215) | 2 | 4 | 5 | 28862 | 22 | ||
172957 | 40642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.7443667457738 | -122.410880064189 | (37.7443667457738, -122.410880064189) | 2 | 7 | 7 | 28859 | 2 | |||
173663 | 37275 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3894 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39816 | 6002513.25180394 | 2102998.13185029 | 37.754574335137 | -122.434249400487 | (37.754574335137, -122.434249400487) | 2 | 4 | 5 | 28862 | 22 | |||
174203 | 37705 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
180479 | 35494 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3763 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38905 | 6005241.37948762 | 2104264.99377415 | 37.758207308358 | -122.424904929122 | (37.758207308358, -122.424904929122) | 2 | 4 | 5 | 28859 | 19 | ||
183814 | 37700 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
183856 | 35549 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 50 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.424455886685 | (37.7558983622011, -122.424455886685) | 2 | 4 | 5 | 28859 | 19 | ||
184586 | 37749 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1271 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1999 12:00:00 AM | Permit Number 40096 | 6009537.93489258 | 2101780.18844977 | 37.7516263413346 | -122.409870111191 | (37.7516263413346, -122.409870111191) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );