trees
400 rows where qSpecies_id = 43 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25563 | 36489 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
97659 | 36491 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
119125 | 36493 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
140321 | 36492 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
144944 | 36488 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
173715 | 36487 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
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 | ||
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 | ||
173394 | 64645 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856 | 37.7288421898975 | -122.460097287553 | (37.7288421898975, -122.460097287553) | 9 | 7 | 4 | 28861 | 40 | ||
29470 | 45414 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
120572 | 45413 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
30149 | 34482 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 840 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38209 | 6008945.03028541 | 2119415.9766962 | 37.8000168102383 | -122.413167394928 | (37.8000168102383, -122.413167394928) | 3 | 1 | 10 | 308 | 32 | ||
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 | ||
72189 | 38209 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 830 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40332 | 6010874.68113014 | 2090828.02861629 | 37.7216288654759 | -122.40447659257 | (37.7216288654759, -122.40447659257) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
169396 | 33344 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.464001399226 | (37.730182659203, -122.464001399226) | 9 | 8 | 4 | 59 | 40 | ||
162751 | 43695 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | 11 | 6 | 2 | 54 | 11 | ||
64036 | 43694 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 750 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43338 | 5993218.66242977 | 2110366.15850001 | 37.7742730687673 | -122.46692789928 | (37.7742730687673, -122.46692789928) | 11 | 6 | 2 | 54 | 11 | ||
34181 | 68180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 75 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31952 | 5996329.36645327 | 2111693.70801186 | 37.7780972208044 | -122.456263479509 | (37.7780972208044, -122.456263479509) | 11 | 6 | 2 | 54 | 16 | ||
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 | ||
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 | ||
74322 | 39707 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41092 | 5997200.32170515 | 2095026.51323817 | 37.7323832338006 | -122.452047720375 | (37.7323832338006, -122.452047720375) | 9 | 7 | 4 | 59 | 40 | ||
184921 | 38197 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 731 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40324 | 6011355.00492598 | 2091469.0696772 | 37.7234158640083 | -122.402861294571 | (37.7234158640083, -122.402861294571) | 10 | 3 | 7 | 309 | 28 | ||
23158 | 38196 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 730 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | 10 | 3 | 7 | 309 | 28 | ||
181109 | 38195 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 730 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | 10 | 3 | 7 | 309 | 28 | ||
176487 | 34803 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
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 | ||
25595 | 247352 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 717 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003091.9924 | 2109593.0641 | 37.7727152549133 | -122.432719040926 | (37.7727152549133, -122.432719040926) | 15 | 5 | 11 | 29492 | 9 | |||
46836 | 37543 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 704 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | 5 | 1 | 10 | 28858 | 21 | ||
159345 | 37542 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 704 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | 5 | 1 | 10 | 28858 | 21 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
155289 | 31184 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | 9 | 8 | 6 | 64 | 24 | ||
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 | ||
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 | ||
64456 | 42029 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | 9 | 8 | 4 | 59 | 40 | ||
86559 | 38511 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 64 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1998 12:00:00 AM | Permit Number 40500 | 6008516.43042503 | 2087785.37039582 | 37.7131422875132 | -122.412413505045 | (37.7131422875132, -122.412413505045) | 9 | 7 | 8 | 309 | 39 | |||
94534 | 42120 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 630 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/2002 12:00:00 AM | Permit Number 42417 | 5997254.13334531 | 2095296.10071131 | 37.7331265386983 | -122.451881123727 | (37.7331265386983, -122.451881123727) | 9 | 7 | 4 | 59 | 40 | ||
23688 | 68883 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | 10 | 3 | 8 | 58 | 1 | ||
101538 | 39689 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 56 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41074 | 6013706.29242939 | 2094956.2180602 | 37.7331218759444 | -122.394977388495 | (37.7331218759444, -122.394977388495) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | ||
162238 | 68548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.7783322447781 | -122.504940366327 | (37.7783322447781, -122.504940366327) | 11 | 6 | 2 | 55 | 26 | ||
155194 | 55092 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.7779243407011 | -122.474992253786 | (37.7779243407011, -122.474992253786) | 11 | 6 | 2 | 54 | 26 | ||
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 | ||
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 | ||
106945 | 140845 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
43841 | 39675 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
100219 | 39676 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
41684 | 68560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.7786889858471 | -122.506043321809 | (37.7786889858471, -122.506043321809) | 11 | 6 | 2 | 55 | 26 | ||
28494 | 42555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
143304 | 42554 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
190993 | 42556 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
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 | ||
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 | ||
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 | ||
89187 | 251679 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011495 | 2091622 | 37.7238435952898 | -122.402388102511 | (37.7238435952898, -122.402388102511) | 10 | 3 | 7 | 309 | 28 | |||||
136441 | 38176 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40311 | 6011565.07182758 | 2091659.31063556 | 37.7239499540685 | -122.402148496173 | (37.7239499540685, -122.402148496173) | 10 | 3 | 7 | 309 | 28 | ||
129953 | 42147 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 490 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42443 | 5990026.73861506 | 2112033.51240967 | 37.7786664170583 | -122.478091152159 | (37.7786664170583, -122.478091152159) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
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 | ||
67090 | 90956 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.43871 | 2110931.20899 | 37.7751208933778 | -122.508698002643 | (37.7751208933778, -122.508698002643) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
77362 | 42163 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4630 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42458 | 5989047.18920071 | 2109907.45432155 | 37.7727719459225 | -122.481324019174 | (37.7727719459225, -122.481324019174) | 11 | 6 | 2 | 55 | 26 | ||
86025 | 38199 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 455 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40326 | 6010407.74547618 | 2092510.58020697 | 37.7262226967111 | -122.406209156508 | (37.7262226967111, -122.406209156508) | 10 | 3 | 7 | 309 | 28 | ||
79658 | 141253 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | 11 | 6 | 1 | 54 | 31 | |||
180365 | 141254 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | 11 | 6 | 1 | 54 | 31 | |||
22083 | 36334 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
75770 | 36336 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
189493 | 36335 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
43878 | 38172 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 433 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40308 | 6010665.04465284 | 2092691.20819375 | 37.7267330524509 | -122.405332397121 | (37.7267330524509, -122.405332397121) | 10 | 3 | 7 | 309 | 28 | ||
31546 | 37131 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4234 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 6 | Permit Number 39713 | 5981666.4542 | 2104905.7911 | 37.7586069464275 | -122.506483373023 | (37.7586069464275, -122.506483373023) | 1 | 8 | 3 | 56 | 35 | |
32817 | 37130 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4234 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 4 | Permit Number 39713 | 5981688.5295 | 2104905.7911 | 37.758608246146 | -122.506407027964 | (37.758608246146, -122.506407027964) | 1 | 8 | 3 | 56 | 35 | |
49100 | 37124 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4200 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | 1 | 8 | 3 | 56 | 35 | |
126430 | 37123 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4200 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | 1 | 8 | 3 | 56 | 35 | |
146257 | 37125 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4200 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | 1 | 8 | 3 | 56 | 35 | |
179341 | 38180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 42 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40313 | 6011447.25206772 | 2091677.58315317 | 37.7239935496068 | -122.402557066965 | (37.7239935496068, -122.402557066965) | 10 | 3 | 7 | 309 | 28 | ||
63942 | 31145 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | |
146965 | 31139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 419 Hearst Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | ||
114140 | 43109 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
148461 | 43110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
27476 | 31110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
54982 | 31111 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
132556 | 43498 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43178 | 6008355.55350511 | 2095881.30836855 | 37.7353629859312 | -122.413541790025 | (37.7353629859312, -122.413541790025) | 10 | 7 | 7 | 28859 | 2 | ||
172758 | 102442 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008344 | 2095883 | 37.735366982035 | -122.413581854524 | (37.735366982035, -122.413581854524) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | ||
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 | ||
69645 | 43105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
128913 | 43106 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
150403 | 43108 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 |
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) );