trees
400 rows where qSpecies_id = 43 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
1543 | 259573 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 298 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
3187 | 70368 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.501507359539 | (37.7598111971708, -122.501507359539) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||||
7624 | 246397 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264093 | -122.445696997639 | (37.769264264093, -122.445696997639) | 15 | 5 | 11 | 29492 | 9 | |||
9754 | 82920 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982872.9956 | 2103302.6049 | 37.7542760130661 | -122.502192036803 | (37.7542760130661, -122.502192036803) | 1 | 8 | 3 | 56 | 35 | |||
10339 | 73455 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009841.50181 | 2111066.87201 | 37.777142462881 | -122.409475680552 | (37.777142462881, -122.409475680552) | 8 | 2 | 9 | 28853 | 34 | |||
10370 | 72596 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1551 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988056.3788 | 2104735.0481 | 37.7585122851486 | -122.484371869742 | (37.7585122851486, -122.484371869742) | 1 | 8 | 3 | 56 | 35 | |||
13763 | 72614 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1586 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987797.3449 | 2104500.8291 | 37.7578540967372 | -122.485250528016 | (37.7578540967372, -122.485250528016) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
29364 | 183465 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2530 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5988020.0365 | 2098057.021 | 37.7401740893942 | -122.484007860756 | (37.7401740893942, -122.484007860756) | 1 | 8 | 3 | 29491 | 35 | |||
32117 | 183413 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2350 Wawona St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985629.7915 | 2097026.6067 | 37.737205400625 | -122.492196390733 | (37.737205400625, -122.492196390733) | 1 | 8 | 3 | 29491 | 35 | |||
32393 | 246393 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.7692955761214 | -122.445463083857 | (37.7692955761214, -122.445463083857) | 15 | 5 | 11 | 29492 | 9 | |||
36106 | 182248 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1454 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985596.8527 | 2105324.6327 | 37.7599875985541 | -122.492921320569 | (37.7599875985541, -122.492921320569) | 1 | 8 | 3 | 56 | 35 | |||
36889 | 207426 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 404 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6000774.5178 | 2095253.08109 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | 9 | 7 | 5 | 63 | 40 | ||||
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 | |||
49210 | 114656 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6001274.7016 | 2113900.9823 | 37.78444047533 | -122.439314075739 | (37.78444047533, -122.439314075739) | 15 | 6 | 11 | 29490 | 13 | |||
49579 | 114652 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001448.056 | 2113923.3749 | 37.7845118231904 | -122.438715935573 | (37.7845118231904, -122.438715935573) | 15 | 6 | 11 | 29490 | 13 | |||
58011 | 246391 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1302 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999418.9163 | 2108430.2253 | 37.7693133969257 | -122.445340943975 | (37.7693133969257, -122.445340943975) | 15 | 5 | 11 | 29492 | 9 | |||
63515 | 207425 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991937.91081 | 2090925.40696 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | 9 | 8 | 6 | 64 | 24 | |||
64436 | 114654 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001378.1104 | 2113915.8269 | 37.7844871189173 | -122.438957381866 | (37.7844871189173, -122.438957381866) | 15 | 6 | 11 | 29490 | 13 | |||
64957 | 9986 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | ||
65565 | 246392 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1310 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999402.5635 | 2108427.4999 | 37.7693049801732 | -122.445397311319 | (37.7693049801732, -122.445397311319) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
68367 | 14603 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1265 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 5999439.61797 | 2108531.98026 | 37.7695939720606 | -122.44527665521 | (37.7695939720606, -122.44527665521) | 15 | 5 | 11 | 29492 | 9 | |||
68850 | 187339 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985079.354 | 2099690.9452 | 37.7444887635366 | -122.494295807794 | (37.7444887635366, -122.494295807794) | 1 | 8 | 3 | 29491 | 35 | |||
74396 | 121619 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 1465 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 6012073 | 2101555 | 37.7511497699027 | -122.401087656443 | (37.7511497699027, -122.401087656443) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | |||
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 | |||
86065 | 29418 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.389566117231 | (37.7227927176508, -122.389566117231) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||||
91288 | 106921 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | 8 | 4 | 7 | 28853 | 19 | |||
91821 | 246394 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999365.9212 | 2108422.0489 | 37.7692879212962 | -122.445523662753 | (37.7692879212962, -122.445523662753) | 15 | 5 | 11 | 29492 | 9 | |||
99430 | 184739 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | 1 | 8 | 3 | 56 | 35 | |||
102213 | 99920 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
106912 | 246396 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251 | -122.445638557414 | (37.769273547251, -122.445638557414) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
124314 | 246395 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999349.2656 | 2108419.0206 | 37.7692786554823 | -122.445581055639 | (37.7692786554823, -122.445581055639) | 15 | 5 | 11 | 29492 | 9 | |||
139804 | 191035 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.7770895827422 | -122.409412667772 | (37.7770895827422, -122.409412667772) | 8 | 2 | 9 | 28853 | 34 | |||
150043 | 246390 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.445287080875 | (37.7694174354079, -122.445287080875) | 15 | 5 | 11 | 29492 | 9 | |||
161440 | 9987 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | |||
161625 | 126462 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.8038772290062 | -122.441595650935 | (37.8038772290062, -122.441595650935) | 13 | 9 | 1 | 57 | 17 | |||
163727 | 184740 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.7624423230543 | -122.496090619994 | (37.7624423230543, -122.496090619994) | 1 | 8 | 3 | 56 | 35 | |||
166774 | 141601 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | 15 | 5 | 11 | 29492 | 16 | |||
172638 | 126461 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000743.63592 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
177763 | 255250 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 209x Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
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 | |||
180644 | 248448 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | ||
100897 | 68054 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1881 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31791 | 5993737.20481548 | 2102706.11474697 | 37.7532705090115 | -122.46457785688 | (37.7532705090115, -122.46457785688) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||
59370 | 68249 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | 13 | 9 | 1 | 57 | 17 | ||
160336 | 68399 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | 9 | 8 | 4 | 59 | 40 | ||
12226 | 68412 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | 9 | 8 | 4 | 59 | 40 | ||
178201 | 68496 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | 1 | 8 | 4 | 56 | 12 | ||
68189 | 68517 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | 1 | 8 | 4 | 29491 | 12 | ||
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 | ||
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 | ||
93886 | 68599 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.473171429533 | (37.7517787113613, -122.473171429533) | 1 | 8 | 4 | 29491 | 12 | ||
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 | ||
67615 | 69146 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2479 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33181 | 5983616.53937475 | 2098288.7238606 | 37.7405529339472 | -122.499250248288 | (37.7405529339472, -122.499250248288) | 1 | 8 | 3 | 29491 | 35 | ||
190034 | 69279 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1935 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33350 | 5991240.95366227 | 2102241.42925325 | 37.7518503834746 | -122.473176432428 | (37.7518503834746, -122.473176432428) | 1 | 8 | 4 | 29491 | 12 | ||
29636 | 69317 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2122 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 6 | Permit Number 33397 | 5987643.2305 | 2104427.6901 | 37.7576442978234 | -122.485778145282 | (37.7576442978234, -122.485778145282) | 1 | 8 | 3 | 56 | 35 | |
94076 | 31013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
31634 | 31124 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 15 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | 9 | 7 | 4 | 28861 | 40 | ||
36936 | 31125 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | 9 | 7 | 4 | 28861 | 40 | ||
22627 | 31126 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34843 | 5998070.7770048 | 2093598.16198917 | 37.7285111411981 | -122.448935514449 | (37.7285111411981, -122.448935514449) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||
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 | ||
131078 | 31826 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
172252 | 31827 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
139708 | 31829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
156451 | 31830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
180904 | 34527 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | |||
189659 | 34528 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | ||
83598 | 34569 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665 | (37.7401467112036, -122.41215832665) | 10 | 7 | 7 | 28859 | 2 | ||
140509 | 34630 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1766 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38311 | 5988776.9552 | 2103320.2277 | 37.7546695008183 | -122.481776191509 | (37.7546695008183, -122.481776191509) | 1 | 8 | 3 | 56 | 35 | |
193773 | 34629 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1766 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 6 | Permit Number 38311 | 5988774.7652 | 2103307.0873 | 37.7546332934455 | -122.481782802584 | (37.7546332934455, -122.481782802584) | 1 | 8 | 3 | 56 | 35 | |
103016 | 34646 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1596 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38325 | 5987803.91965419 | 2104439.10360026 | 37.7576849982837 | -122.48522326103 | (37.7576849982837, -122.48522326103) | 1 | 8 | 3 | 56 | 35 | |||
17683 | 34648 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1591 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38327 | 5987753.8097 | 2104490.816 | 37.7578240672557 | -122.485400354271 | (37.7578240672557, -122.485400354271) | 1 | 8 | 3 | 56 | 35 |
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) );