403 rows where qLegalStatus_id = 7 and qSpecies_id = 95 sorted by qAddress descending

View and edit SQL

qLegalStatus_id

  • Permitted Site · 403
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)
92555 9315 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99X Gold Mine Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     40 2X2   6001391.6487444 2098856.3848919 37.7431383606087 -122.437831565564 (37.7431383606087, -122.437831565564) 2 7 5 63 7
125252 9316 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99X Gold Mine Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     8 2X2   6001391.6487444 2098856.3848919 37.7431383606087 -122.437831565564 (37.7431383606087, -122.437831565564) 2 7 5 63 7
89783 62806 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 998 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23165 6001478.75963757 2111822.72775324 37.7787457270266 -122.438459155796 (37.7787457270266, -122.438459155796) 15 5 11 29490 41
159191 67468 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99 Agua Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM     Permit Number 30989 5996784.33302359 2098587.30616541 37.7421364707665 -122.453742919924 (37.7421364707665, -122.453742919924) 9 7 4 59 40
170039 66650 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 987 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1991 12:00:00 AM     Permit Number 29864 6009988.37334471 2103470.11092484 37.756291725608 -122.408431620376 (37.756291725608, -122.408431620376) 2 4 7 28859 19
187125 97314 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 939 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990332.7 2099029.1 37.7429775357045 -122.47608267022 (37.7429775357045, -122.47608267022) 1 8 3 29491 35
155228 59897 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 935 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1981 12:00:00 AM     Permit Number 19364 6009972.36860378 2103760.42694535 37.7570879720238 -122.408507448602 (37.7570879720238, -122.408507448602) 2 4 7 28859 19
110357 68762 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 93 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32685 6003698.93163887 2105058.11986312 37.7602977987445 -122.430295967154 (37.7602977987445, -122.430295967154) 2 4 5 28862 3
136759 59579 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 927 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/1981 12:00:00 AM     Permit Number 18970 6003789.07687713 2102877.39607129 37.7543151544522 -122.429828648461 (37.7543151544522, -122.429828648461) 2 4 5 28862 22
122446 59904 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 917 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1981 12:00:00 AM 20 3x5 Permit Number 19372 6009966.82850106 2103860.92095406 37.7573635957508 -122.408533697213 (37.7573635957508, -122.408533697213) 2 4 7 28859 19
115167 63674 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 911 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1987 12:00:00 AM     Permit Number 24326 5999505.51324752 2111590.21998339 37.7779948811468 -122.445268639971 (37.7779948811468, -122.445268639971) 15 5 11 54 16
116879 65462 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 901 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28340 5995002.55717105 2089937.23341469 37.7182831614911 -122.459277439941 (37.7182831614911, -122.459277439941) 9 8 6 28861 24
91249 68114 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 9 Powers Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31860 6006758.25542917 2099860.24648368 37.7461984425313 -122.419346431514 (37.7461984425313, -122.419346431514) 2 7 7 28859 2
49431 67556 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 890 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/1995 12:00:00 AM     Permit Number 31105 6003602.07514471 2110752.33262694 37.7759272362097 -122.43103736444 (37.7759272362097, -122.43103736444) 7 9 11 29492 10
106922 55944 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 88 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23659 6007320.31270833 2098871.4635855 37.7435151059243 -122.41733284358 (37.7435151059243, -122.41733284358) 2 7 7 28859 2
29456 44432 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 859 Prague St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43768 6002153.12936878 2086903.35597383 37.7103613194328 -122.43434417838 (37.7103613194328, -122.43434417838) 9 7 6 28861 5
41816 44422 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 859 Prague St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43768 6002153.12936878 2086903.35597383 37.7103613194328 -122.43434417838 (37.7103613194328, -122.43434417838) 9 7 6 28861 5
82780 44427 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 859 Prague St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43768 6002153.12936878 2086903.35597383 37.7103613194328 -122.43434417838 (37.7103613194328, -122.43434417838) 9 7 6 28861 5
85575 44435 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 859 Prague St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43768 6002153.12936878 2086903.35597383 37.7103613194328 -122.43434417838 (37.7103613194328, -122.43434417838) 9 7 6 28861 5
160852 44424 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 859 Prague St 18 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43768 6002153.12936878 2086903.35597383 37.7103613194328 -122.43434417838 (37.7103613194328, -122.43434417838) 9 7 6 28861 5
164639 44426 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 859 Prague St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43768 6002153.12936878 2086903.35597383 37.7103613194328 -122.43434417838 (37.7103613194328, -122.43434417838) 9 7 6 28861 5
169603 61117 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 858 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1983 12:00:00 AM     Permit Number 20965 6007941.19441974 2102928.68119709 37.7546902263284 -122.415473162557 (37.7546902263284, -122.415473162557) 2 4 7 28859 19
118548 64949 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 855 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1992 12:00:00 AM     Permit Number 25980 6000877.59992491 2102564.82101666 37.7532915955721 -122.439874838937 (37.7532915955721, -122.439874838937) 2 4 5 28862 22
170784 61120 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 852 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1983 12:00:00 AM   3x3 Permit Number 20968 6007939.33353128 2102962.26711257 37.7547823410171 -122.415481975691 (37.7547823410171, -122.415481975691) 2 4 7 28859 19
168128 63755 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 832 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24429 6002579.84478406 2109569.92728925 37.7726226680298 -122.434488959034 (37.7726226680298, -122.434488959034) 15 5 11 29492 9
58354 61096 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 824 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1983 12:00:00 AM     Permit Number 20935 6007930.64938321 2103119.00141964 37.7552122096322 -122.415523103949 (37.7552122096322, -122.415523103949) 2 4 7 28859 19
188286 61116 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 822 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1983 12:00:00 AM     Permit Number 20963 6007930.02908725 2103130.19672131 37.7552429145151 -122.415526041698 (37.7552429145151, -122.415526041698) 2 4 7 28859 19
19188 50842 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 82 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2004 12:00:00 AM     Permit Number 47359 5993044.92804396 2098532.41947398 37.7417706745335 -122.466668512936 (37.7417706745335, -122.466668512936) 1 8 4 59 40
180832 61118 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 814 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1983 12:00:00 AM     Permit Number 20966 6007927.54790196 2103174.97795415 37.7553657341162 -122.415537792727 (37.7553657341162, -122.415537792727) 2 4 7 28859 19
21636 51458 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 808 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/25/2005 12:00:00 AM     Permit Number 47774 6008145.26654848 2095639.85108007 37.7346881866787 -122.414251754332 (37.7346881866787, -122.414251754332) 2 7 7 28859 2
166566 62573 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 801 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1986 12:00:00 AM     Permit Number 22776 6011595.8787413 2104633.73265 37.7595766638959 -122.402954119848 (37.7595766638959, -122.402954119848) 10 3 8 28856 29
141052 61099 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 800 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1983 12:00:00 AM     Permit Number 20940 6007923.20582822 2103253.34510246 37.7555806683839 -122.415558357118 (37.7555806683839, -122.415558357118) 2 4 7 28859 19
99246 62678 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 80 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23010 6002873.63251786 2108816.3300199 37.7705701481356 -122.43341885509 (37.7705701481356, -122.43341885509) 15 5 5 29492 9
106473 67781 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 79 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1992 12:00:00 AM     Permit Number 31415 6003192.55557478 2107842.98857257 37.7679156790923 -122.432246173934 (37.7679156790923, -122.432246173934) 15 5 5 28862 3
68546 62677 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 79 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23009 6002822.87461498 2108803.77757194 37.7705328023747 -122.433593529779 (37.7705328023747, -122.433593529779) 15 5 5 29492 9
69484 62676 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 76 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23008 6002875.51834221 2108802.71309796 37.7705328664051 -122.433411358794 (37.7705328664051, -122.433411358794) 15 5 5 29492 9
101738 65671 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 759 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28591 5999036.51165566 2095907.91255274 37.7349083558011 -122.445762972308 (37.7349083558011, -122.445762972308) 9 7 4 59 40
166868 10321 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 759 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6002536.32245 2109085.56364 37.7712902545388 -122.434604866834 (37.7712902545388, -122.434604866834) 15 5 11 29492 9
31098 63328 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 75 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1987 12:00:00 AM     Permit Number 23901 6009622.07115368 2099898.67232456 37.7464648291666 -122.409446382283 (37.7464648291666, -122.409446382283) 2 7 7 28859 2
159391 63139 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 75 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23660 6007418.4427162 2098943.4214592 37.74371820671 -122.416998630994 (37.74371820671, -122.416998630994) 2 7 7 28859 2
48393 63053 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 744 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23524 5992604.95874297 2105278.27708431 37.7602676590712 -122.468680505751 (37.7602676590712, -122.468680505751) 1 8 4 56 12
127118 66393 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 741 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29519 6007775.9235659 2095463.88536749 37.7341842695898 -122.415516248299 (37.7341842695898, -122.415516248299) 2 7 7 28859 2
170639 63052 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 740 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23523 5992616.86380837 2105278.68425229 37.7602694647792 -122.468639361712 (37.7602694647792, -122.468639361712) 1 8 4 56 12
135598 63051 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 736 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23522 5992628.76886265 2105279.09141988 37.7602712704712 -122.46859821771 (37.7602712704712, -122.46859821771) 1 8 4 56 12
119117 63752 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 722 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24425 6003101.35751437 2109641.71994707 37.772849383001 -122.432690122287 (37.772849383001, -122.432690122287) 15 5 11 29492 9
156501 63178 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 720 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23716 5992676.38910758 2105280.72009122 37.7602784930998 -122.468433641583 (37.7602784930998, -122.468433641583) 1 8 4 56 12
61445 66389 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 711 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29515 6007791.32662379 2095624.44985276 37.7346260104333 -122.41547435861 (37.7346260104333, -122.41547435861) 2 7 7 28859 2
137438 66370 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 710 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29494 6007739.56425491 2095629.41545125 37.7346367352991 -122.415653670559 (37.7346367352991, -122.415653670559) 2 7 7 28859 2
179896 63641 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 701 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31106 6001035.54169923 2111072.80974441 37.7766614211292 -122.43993863172 (37.7766614211292, -122.43993863172) 15 5 11 29492 41
180278 65361 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 7 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1989 12:00:00 AM     Permit Number 28196 6002832.7941803 2095807.19286717 37.7348478258508 -122.432630712358 (37.7348478258508, -122.432630712358) 2 7 5 63 7
182456 55778 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 690 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1992 12:00:00 AM     Permit Number 30413 6004270.54633332 2104877.95135901 37.7598354599097 -122.428306178244 (37.7598354599097, -122.428306178244) 2 4 5 28862 3
143804 88992 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 680 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013080.3 2113726.9 37.784627230328 -122.398458274764 (37.784627230328, -122.398458274764) 6 2 9 28853 6
189339 64316 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 68 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/1988 12:00:00 AM     Permit Number 25133 6004266.78630985 2097807.98626151 37.740422769496 -122.427815418773 (37.740422769496, -122.427815418773) 2 7 5 63 7
98844 62675 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 67 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23007 6002828.41663184 2108763.7604774 37.7704232397192 -122.433571499613 (37.7704232397192, -122.433571499613) 15 5 5 29492 9
157627 63327 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 67 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1987 12:00:00 AM     Permit Number 23900 6009588.27522653 2099896.70340901 37.7464575292866 -122.409563106368 (37.7464575292866, -122.409563106368) 2 7 7 28859 2
112299 61371 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 666 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24723 6003005.23530154 2104469.02923152 37.7586409802374 -122.432653055314 (37.7586409802374, -122.432653055314) 2 4 5 28862 3
97839 63454 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 650 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1987 12:00:00 AM     Permit Number 24044 6007400.45392955 2095982.88563367 37.7355882186861 -122.416851127023 (37.7355882186861, -122.416851127023) 2 7 7 28859 2
113409 92745 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 65 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2009 12:00:00 AM     Permit Number 52969 6006237.3 2110147.2 37.7744146578956 -122.42187842919 (37.7744146578956, -122.42187842919) 7 9 11 28852 10
44095 61324 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 644 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1984 12:00:00 AM     Permit Number 21227 6000113.71348452 2111091.95490502 37.776661470532 -122.443128871484 (37.776661470532, -122.443128871484) 15 5 11 29492 16
34766 62075 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 640 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1985 12:00:00 AM     Permit Number 22157 6013257.98331127 2104095.18342465 37.7581905974819 -122.397167930647 (37.7581905974819, -122.397167930647) 10 3 8 28856 29
38656 65308 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 64 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28127 6005982.44079017 2105130.61413387 37.7606259299013 -122.422403517998 (37.7606259299013, -122.422403517998) 2 4 5 28859 19
123195 67196 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 635 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30648 5998644.57725532 2105576.2122968 37.7614327642251 -122.447813838506 (37.7614327642251, -122.447813838506) 15 5 11 29492 12
175140 49058 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 634 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46225 5995429.55733009 2093557.30564002 37.7282475554757 -122.458063335473 (37.7282475554757, -122.458063335473) 9 7 4 28861 40
178593 49057 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 634 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46225 5995429.55733009 2093557.30564002 37.7282475554757 -122.458063335473 (37.7282475554757, -122.458063335473) 9 7 4 28861 40
150267 67037 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 620 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1992 12:00:00 AM     Permit Number 30412 6004248.3695844 2105283.39712956 37.7609474626645 -122.428411775349 (37.7609474626645, -122.428411775349) 2 4 5 28862 3
175969 63141 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 62 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/1986 12:00:00 AM     Permit Number 23663 6007664.9477406 2099130.85526884 37.7442467216038 -122.416159545157 (37.7442467216038, -122.416159545157) 2 7 7 28859 2
59365 18544 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 61X Quartz Way 4 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   5999058.055369 2099782.1056805 37.7455471938994 -122.445967045704 (37.7455471938994, -122.445967045704) 2 7 5 63 22
151497 63643 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 615 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1987 12:00:00 AM     Permit Number 24290 6001076.3999006 2110778.3153622 37.7758551396753 -122.439776172675 (37.7758551396753, -122.439776172675) 15 5 11 29492 10
179550 63050 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 614 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1986 12:00:00 AM     Permit Number 23521 5993003.74636017 2105291.91602449 37.7603281373616 -122.467302290195 (37.7603281373616, -122.467302290195) 1 8 4 56 12
28451 64133 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 610 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24904 6002610.61709759 2098908.05619778 37.7433494776015 -122.433620394679 (37.7433494776015, -122.433620394679) 2 7 5 63 22
152485 56760 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 601 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23012 6002834.07750169 2108857.67931185 37.7706814389316 -122.433558631653 (37.7706814389316, -122.433558631653) 15 5 5 29492 9
66310 69429 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 600 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1994 12:00:00 AM     Permit Number 33535 6010075.47588455 2105486.09758826 37.7618320485731 -122.408272572771 (37.7618320485731, -122.408272572771) 2 4 8 28859 19
120503 58678 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 596 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24398 6003287.0157035 2109320.57844586 37.7719781347946 -122.43202497289 (37.7719781347946, -122.43202497289) 15 9 11 29492 10
101078 47926 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 59 Arroyo Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2002 12:00:00 AM     Permit Number 45662 5998719.5492526 2097291.29425363 37.7386886899437 -122.44695833479 (37.7386886899437, -122.44695833479) 9 7 4 59 40
15794 63736 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 585 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24405 6003780.00958588 2109683.67127267 37.7730030357559 -122.430345580362 (37.7730030357559, -122.430345580362) 7 9 11 29492 10
173258 60174 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 58 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19706 6005980.54267334 2105164.87188329 37.7607198865759 -122.422412516922 (37.7607198865759, -122.422412516922) 2 4 5 28859 19
53445 63259 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 58 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/1987 12:00:00 AM     Permit Number 23812 6007675.47981735 2099150.37984096 37.7443009239155 -122.41612450988 (37.7443009239155, -122.41612450988) 2 7 7 28859 2
54480 47970 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 576 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45700 5998868.81071555 2097070.39431327 37.7380906778158 -122.446426373957 (37.7380906778158, -122.446426373957) 9 7 4 59 40
40120 66387 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 576 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29513 6003809.30522061 2109740.24975223 37.7731600457631 -122.430248280428 (37.7731600457631, -122.430248280428) 7 9 11 29492 10
149176 63737 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 573 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24406 6003834.70515324 2109691.28362316 37.7730270354143 -122.43015692487 (37.7730270354143, -122.43015692487) 7 9 11 29492 10
149496 47969 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 571 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45699 5998926.83407874 2097073.47260049 37.7381024439433 -122.446225980415 (37.7381024439433, -122.446225980415) 9 7 4 59 40
126958 62504 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 571 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22679 6001219.48180727 2103032.28058785 37.7545945820306 -122.438726037561 (37.7545945820306, -122.438726037561) 2 4 5 28862 22
174834 65309 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 57 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28128 6006032.10149289 2105174.27390914 37.7607486106903 -122.422234865835 (37.7607486106903, -122.422234865835) 2 4 5 28859 19
124906 62567 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 566 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1986 12:00:00 AM     Permit Number 22768 6011492.88408448 2105735.21386833 37.7625953337074 -122.403387819029 (37.7625953337074, -122.403387819029) 8 3 8 28856 29
95251 81819 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 56 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50797 6001670.65658428 2105505.28086123 37.7614104988666 -122.437342827434 (37.7614104988666, -122.437342827434) 15 4 5 28862 3
143477 63108 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 56 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1986 12:00:00 AM     Permit Number 23611 6007680.7458509 2099160.14211808 37.7443280250424 -122.416106992238 (37.7443280250424, -122.416106992238) 2 7 7 28859 2
41371 62502 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 559 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22677 6001216.54610272 2103082.94453689 37.754733525989 -122.438739820196 (37.754733525989, -122.438739820196) 2 4 5 28862 22
27708 62501 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 553 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22676 6001215.07825091 2103108.27650352 37.7548029979447 -122.438746711531 (37.7548029979447, -122.438746711531) 2 4 5 28862 22
83304 63735 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 550 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1987 12:00:00 AM     Permit Number 24404 6003927.8122889 2109756.74317909 37.7732120443049 -122.429839525756 (37.7732120443049, -122.429839525756) 7 9 11 29492 10
47550 63734 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 547 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24403 6003953.21225561 2109707.77705475 37.7730790336555 -122.429748170749 (37.7730790336555, -122.429748170749) 7 9 11 29492 10
59789 62500 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 545 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1986 12:00:00 AM     Permit Number 22675 6001213.12111484 2103142.05246429 37.7548956272315 -122.438755899998 (37.7548956272315, -122.438755899998) 2 4 5 28862 22
118199 66519 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 541 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1991 12:00:00 AM     Permit Number 29690 6001212.14254636 2103158.94045257 37.7549419418957 -122.438760494243 (37.7549419418957, -122.438760494243) 2 4 5 28862 22
185379 9032 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 5401 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM 12 3X3   5990239.95827 2112557.38019 37.7801171867577 -122.477391848024 (37.7801171867577, -122.477391848024) 11 6 2 55 26
50956 63760 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 540 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24437 6003973.39193973 2109763.08680608 37.7732320433706 -122.429682312236 (37.7732320433706, -122.429682312236) 7 9 11 29492 10
85892 5030 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 5325 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2   6001666.1669313 2098898.9593405 37.743270866325 -122.436885403782 (37.743270866325, -122.436885403782) 2 7 5 63 22
28918 5016 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 5319 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2   6001623.7265968 2098938.5095602 37.7433770497021 -122.43703498209 (37.7433770497021, -122.43703498209) 2 7 5 63 22
174388 63732 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 529 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24401 6004035.25561517 2109719.19558167 37.7731150315991 -122.429465186856 (37.7731150315991, -122.429465186856) 7 9 11 29492 10
62472 67728 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 516 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31347 5997107.4486428 2107419.61483204 37.7664063016043 -122.453263185466 (37.7664063016043, -122.453263185466) 15 5 11 29492 8
130596 63731 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 510 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1987 12:00:00 AM     Permit Number 24400 6004110.13087942 2109782.11768526 37.7732920393038 -122.429210671215 (37.7732920393038, -122.429210671215) 7 9 11 29492 10
7453 66398 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 510 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29524 6007445.87739968 2096478.55020646 37.7369517596137 -122.41672918389 (37.7369517596137, -122.41672918389) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);