Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22079 | 22079 | 4859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 17 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000712.83991 | 2098222.9013099996 | 37.7413603416151 | -122.440133283139 | (37.7413603416151, -122.440133283139) | |||
| 22100 | 22100 | 19346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5992530.80337 | 2089863.7154 | 37.717938880250394 | -122.46781582943999 | (37.7179388802504, -122.46781582944) | |||
| 22230 | 22230 | 3451 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 38 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5999519.82118 | 2099605.44915 | 37.745088494646396 | -122.44435764339701 | (37.7450884946464, -122.444357643397) | |||
| 22260 | 22260 | 9373 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 292 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x4 | 6001116.19267 | 2097967.75303 | 37.740682719538796 | -122.438720354687 | (37.7406827195388, -122.438720354687) | |||
| 22477 | 22477 | 9883 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6005400.00219 | 2115093.82301 | 37.787949613228 | -122.42512684742701 | (37.787949613228, -122.425126847427) | |||
| 22486 | 22486 | 21531 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1301 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006257.76496 | 2114889.71602 | 37.7874376040064 | -122.422144632576 | (37.7874376040064, -122.422144632576) | |||
| 22504 | 22504 | 21526 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6006270.376630001 | 2114940.85918 | 37.787578741804204 | -122.422104633424 | (37.7875787418042, -122.422104633424) | |||
| 22511 | 22511 | 21525 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6006287.01156 | 2114943.3231200003 | 37.7875864454 | -122.422047254877 | (37.7875864454, -122.422047254877) | |||
| 22557 | 22557 | 21535 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1337 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006166.93073 | 2114876.17563 | 37.787395301706795 | -122.422457938402 | (37.7873953017068, -122.422457938402) | |||
| 22620 | 22620 | 21530 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1307 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006237.14055 | 2114887.59542 | 37.7874306180636 | -122.422215838204 | (37.7874306180636, -122.422215838204) | |||
| 22786 | 22786 | 9882 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005403.02502 | 2115071.7670299998 | 37.7878892237663 | -122.425114819002 | (37.7878892237663, -122.425114819002) | |||
| 22972 | 22972 | 108950 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | |
| 23011 | 23011 | 7688 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 545 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 0 | 6008696.1209 | 2121067.5649 | 37.8045376819256 | -122.414145630391 | (37.8045376819256, -122.414145630391) | |||
| 23074 | 23074 | 8830 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1993 12:00:00 AM | 4 | 3x3 | 5994612.73133 | 2112879.8624299997 | 37.7812553917023 | -122.462287945756 | (37.7812553917023, -122.462287945756) | ||
| 23397 | 23397 | 54440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.39442879427601 | (37.7598699757444, -122.394428794276) | ||
| 24165 | 24165 | 54475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10267 | 6012323.1841 | 2095334.0847599998 | 37.73408241247979 | -122.399785717559 | (37.7340824124798, -122.399785717559) | ||
| 24354 | 24354 | 54553 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.39818871674801 | (37.7349720434069, -122.398188716748) | ||
| 24699 | 24699 | 54559 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10354 | 6012768.0788 | 2095448.27942 | 37.734420759018604 | -122.398255576836 | (37.7344207590186, -122.398255576836) | ||
| 24798 | 24798 | 45088 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.752114018434206 | -122.484127544226 | (37.7521140184342, -122.484127544226) | |
| 25188 | 25188 | 99927 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 665 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6008996.47999 | 2092997.0616099997 | 37.727479429923896 | -122.411122192648 | (37.7274794299239, -122.411122192648) | ||||
| 25312 | 25312 | 69188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2249 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33230 | 6010676.3293699995 | 2106439.96142 | 37.7644847703853 | -122.40626165736401 | (37.7644847703853, -122.406261657364) | ||
| 27024 | 27024 | 38346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.50417542529499 | (37.7518433707941, -122.504175425295) | |
| 27617 | 27617 | 56389 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.727724951534704 | -122.38635095351299 | (37.7277249515347, -122.386350953513) | ||
| 27713 | 27713 | 61447 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1745 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1994 12:00:00 AM | 7 | Permit Number 33475 | 6004648.5784 | 2118760.76141 | 37.7979756196421 | -122.42798804503599 | (37.7979756196421, -122.427988045036) | ||
| 28106 | 28106 | 32369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 858 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.799974043636205 | -122.413457749072 | (37.7999740436362, -122.413457749072) | ||
| 28761 | 28761 | 54544 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 154 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 11 | Permit Number 10339 | 6009702.32393 | 2095129.7793599998 | 37.7333749787789 | -122.40883247914302 | (37.7333749787789, -122.408832479143) | ||
| 28858 | 28858 | 54973 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 570 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 8 | Permit Number 10851 | 5993170.16242 | 2111603.62161 | 37.7776680101154 | -122.467185660412 | (37.7776680101154, -122.467185660412) | ||
| 29473 | 29473 | 47215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.4762699995 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | |
| 30264 | 30264 | 56315 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 234 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12449 | 5993086.94537 | 2113893.4273099997 | 37.78395039042879 | -122.467640101935 | (37.7839503904288, -122.467640101935) | ||
| 31708 | 31708 | 64202 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.805952304912296 | -122.41917544799401 | (37.8059523049123, -122.419175447994) | ||
| 32062 | 32062 | 101147 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 455 Arkansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6012984.94495 | 2104946.7327099997 | 37.760513561162 | -122.398171964177 | (37.760513561162, -122.398171964177) | |||
| 32737 | 32737 | 69323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2130 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33406 | 6007673.53376 | 2119706.35756 | 37.8007426600105 | -122.417587861288 | (37.8007426600105, -122.417587861288) | ||
| 32882 | 32882 | 45667 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.44646150300801 | (37.8006529814106, -122.446461503008) | ||
| 33255 | 33255 | 66536 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 555 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32084 | 6008859.29808 | 2093449.63302 | 37.7287144005277 | -122.41162839584999 | (37.7287144005277, -122.41162839585) | |
| 33421 | 33421 | 54453 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1305 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 9 | Permit Number 16511 | 6013657.09709 | 2105679.3601599997 | 37.76256261160079 | -122.39589862014 | (37.7625626116008, -122.39589862014) | ||
| 34509 | 34509 | 32604 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.49430610263501 | (37.7622518049359, -122.494306102635) | |
| 34544 | 34544 | 54558 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.9154299998 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | ||
| 35753 | 35753 | 42874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2366 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42798 | 5986118.9683 | 2099141.5396 | 37.7430410269224 | -122.49066066829901 | (37.7430410269224, -122.490660668299) | |
| 35948 | 35948 | 65961 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2567 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 8 | Permit Number 28983 | 5987671.3147 | 2097818.6015 | 37.7394991439696 | -122.485196095129 | (37.7394991439696, -122.485196095129) | ||
| 36235 | 36235 | 43548 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1857 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 4 | Permit Number 43212 | 6000253.363 | 2111274.4996 | 37.777170653454796 | -122.442658894423 | (37.7771706534548, -122.442658894423) | |
| 36239 | 36239 | 54555 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 38 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 12 | 3x3 | Permit Number 10350 | 6012738.64094 | 2095530.58324 | 37.734645108390005 | -122.398363126764 | (37.73464510839, -122.398363126764) | |
| 36306 | 36306 | 56388 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1322 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 12 | Permit Number 12540 | 6016246.7386 | 2092876.1026 | 37.7275512300997 | -122.386049351457 | (37.7275512300997, -122.386049351457) | ||
| 36565 | 36565 | 62056 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | ||
| 37572 | 37572 | 56393 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1367 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12549 | 6015984.5344 | 2092993.9843 | 37.7278603948519 | -122.386964019791 | (37.7278603948519, -122.386964019791) | ||
| 38289 | 38289 | 44471 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 133 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 7 | Permit Number 43785 | 6006112.385480001 | 2093200.59482 | 37.7278761253611 | -122.42110698399799 | (37.7278761253611, -122.421106983998) | |
| 38351 | 38351 | 54970 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 542 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 9 | Permit Number 10848 | 5993164.55901 | 2111769.98644 | 37.778124479556205 | -122.467217143666 | (37.7781244795562, -122.467217143666) | ||
| 38440 | 38440 | 59111 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 662 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 9 | Permit Number 18415 | 5993195.14439 | 2110965.57109 | 37.7759175373362 | -122.467052839991 | (37.7759175373362, -122.467052839991) | ||
| 38626 | 38626 | 82895 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008648.2353300005 | 2110155.46088 | 37.7745730107591 | -122.413539104453 | (37.7745730107591, -122.413539104453) | |
| 39640 | 39640 | 54998 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 534 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 10 | Permit Number 10876 | 5990962.96365 | 2111750.1463 | 37.7779426698765 | -122.474831732013 | (37.7779426698765, -122.474831732013) | ||
| 40433 | 40433 | 53729 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 125 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 12 | Permit Number 9408 | 6012570.8653 | 2095236.57105 | 37.7338284646029 | -122.39892255904199 | (37.7338284646029, -122.398922559042) | ||
| 41049 | 41049 | 43165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 42974 | 6005684.86708 | 2092551.5835900002 | 37.7260699728301 | -122.42253882881201 | (37.7260699728301, -122.422538828812) | |
| 41438 | 41438 | 92558 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52904 | 5989977.22773 | 2113271.83238 | 37.7820636253324 | -122.47835299857799 | (37.7820636253324, -122.478352998578) | |
| 41651 | 41651 | 47841 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45602 | 5981838.80851 | 2110330.1740900003 | 37.773510883288395 | -122.506289537608 | (37.7735108832884, -122.506289537608) | |
| 41822 | 41822 | 53952 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 162 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 11 | Permit Number 9667 | 6009674.27519 | 2095120.19458 | 37.7333470898892 | -122.408928775863 | (37.7333470898892, -122.408928775863) | ||
| 42132 | 42132 | 55307 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | ||
| 42310 | 42310 | 42884 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2514 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42805 | 5985844.8171 | 2098079.769 | 37.7401096713575 | -122.49153045761899 | (37.7401096713575, -122.491530457619) | |
| 42582 | 42582 | 102540 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 295X 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5993671.76443 | 2113576.34059 | 37.783113505313004 | -122.465593815173 | (37.783113505313, -122.465593815173) | |||
| 43059 | 43059 | 55089 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 518 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10986 | 5990960.72715 | 2111836.53902 | 37.778179750938 | -122.47484577629801 | (37.778179750938, -122.474845776298) | ||
| 43429 | 43429 | 31131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34846 | 5997461.35333 | 2093947.48586 | 37.7294354301769 | -122.45106749418001 | (37.7294354301769, -122.45106749418) | |
| 43796 | 43796 | 54707 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1782 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1972 12:00:00 AM | 13 | Permit Number 10542 | 6012472.9912 | 2095604.6829900001 | 37.734833769058 | -122.39928677368299 | (37.734833769058, -122.399286773683) | ||
| 44034 | 44034 | 38344 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | |
| 44157 | 44157 | 55090 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 522 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10987 | 5990959.394619999 | 2111814.6197900004 | 37.778119489538604 | -122.47484878563 | (37.7781194895386, -122.47484878563) | ||
| 44174 | 44174 | 42994 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.723036105202205 | -122.415997529963 | (37.7230361052022, -122.415997529963) | ||
| 44731 | 44731 | 57620 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1315 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 7 | Permit Number 16513 | 6013619.85223 | 2105678.11132 | 37.7625571104404 | -122.396027350002 | (37.7625571104404, -122.396027350002) | ||
| 45005 | 45005 | 53510 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1326 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12541 | 6016208.73 | 2092903.6451 | 37.7276247527235 | -122.386182668022 | (37.7276247527235, -122.386182668022) | ||
| 45611 | 45611 | 43621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.49332687468599 | (37.7480118028434, -122.493326874686) | ||
| 45755 | 45755 | 34141 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2466 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1997 12:00:00 AM | 7 | Permit Number 37989 | 5986144.1807 | 2098458.7736 | 37.7411678068726 | -122.490523271138 | (37.7411678068726, -122.490523271138) | ||
| 46550 | 46550 | 43782 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.293980001 | 2114516.2308400003 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | |
| 46937 | 46937 | 31866 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35308 | 5994462.19495 | 2090280.44973 | 37.7191944696164 | -122.46117009494301 | (37.7191944696164, -122.461170094943) | ||
| 47601 | 47601 | 69335 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2812 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1994 12:00:00 AM | 13 | Permit Number 33420 | 5999154.94286 | 2118460.96082 | 37.796840116743105 | -122.446975936805 | (37.7968401167431, -122.446975936805) | ||
| 48074 | 48074 | 69362 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3521 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33456 | 6002627.22111 | 2120704.3070900002 | 37.8031975232214 | -122.435121592481 | (37.8031975232214, -122.435121592481) | |
| 48184 | 48184 | 56386 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1310 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 13 | Permit Number 12538 | 6016291.3574 | 2092843.6025 | 37.727464460543 | -122.38589283803199 | (37.727464460543, -122.385892838032) | ||
| 49036 | 49036 | 65607 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.42644714752501 | (37.7293249116129, -122.426447147525) |
| 49689 | 49689 | 56181 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 788 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 8 | Permit Number 12289 | 5991026.9623 | 2110070.57762 | 37.77333474205479 | -122.47448773746599 | (37.7733347420548, -122.474487737466) | ||
| 50065 | 50065 | 47679 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.8113599997 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | |
| 50323 | 50323 | 55325 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.0764400002 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) | ||
| 50552 | 50552 | 37144 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 663 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39726 | 5990019.8111 | 2110855.0945599996 | 37.7754304051942 | -122.478028941227 | (37.7754304051942, -122.478028941227) | |||
| 50593 | 50593 | 55186 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.1263700002 | 37.731242767132294 | -122.395999500683 | (37.7312427671323, -122.395999500683) | ||
| 51317 | 51317 | 31863 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 550 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35305 | 5994717.97074246 | 2111781.46316747 | 37.7782455405542 | -122.461844202225 | (37.7782455405542, -122.461844202225) | |||
| 51987 | 51987 | 30475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 424 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1956 12:00:00 AM | 8 | Permit Number 123 | 6010870.8148 | 2119673.484 | 37.8008317865696 | -122.406521568491 | (37.8008317865696, -122.406521568491) | ||
| 52135 | 52135 | 46369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2002 12:00:00 AM | 12 | Permit Number 44606 | 5993652.77755 | 2115385.98394 | 37.788081196911 | -122.465791026812 | (37.788081196911, -122.465791026812) | ||
| 52190 | 52190 | 42235 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 479 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010547.8419 | 2112298.97398 | 37.780565078461706 | -122.407119085392 | (37.7805650784617, -122.407119085392) | |
| 52478 | 52478 | 56160 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 529 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 7 | Permit Number 12268 | 5990914.4091 | 2111783.8388900002 | 37.778032366664796 | -122.475002157716 | (37.7780323666648, -122.475002157716) | ||
| 52921 | 52921 | 66871 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30181 | 6001115.30809688 | 2104289.68730442 | 37.7580411890038 | -122.43917641405001 | (37.7580411890038, -122.43917641405) | ||
| 53282 | 53282 | 53701 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.795401961392706 | -122.44674613035102 | (37.7954019613927, -122.446746130351) | ||
| 53443 | 53443 | 42672 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.80448638863479 | -122.414595938174 | (37.8044863886348, -122.414595938174) | |
| 53842 | 53842 | 54993 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 681 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 4 | Permit Number 10871 | 5990951.138669999 | 2110770.38221 | 37.775251821012795 | -122.474801107552 | (37.7752518210128, -122.474801107552) | ||
| 54274 | 54274 | 56311 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 211 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 7 | Permit Number 12445 | 5993036.2389400005 | 2114024.56075 | 37.784307519182 | -122.467825066835 | (37.784307519182, -122.467825066835) | ||
| 54445 | 54445 | 53953 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 166 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 7 | Permit Number 9668 | 6009649.77155 | 2095111.3186599999 | 37.7333213458895 | -122.40901286606501 | (37.7333213458895, -122.409012866065) | ||
| 54593 | 54593 | 42885 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2546 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42806 | 5985850.2562 | 2097897.6252 | 37.7396098709906 | -122.491498248106 | (37.7396098709906, -122.491498248106) | |
| 54738 | 54738 | 66859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | ||
| 55646 | 55646 | 63097 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3060 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1986 12:00:00 AM | 11 | Permit Number 23584 | 6001459.2061 | 2118948.46858 | 37.798310061319 | -122.439037622007 | (37.798310061319, -122.439037622007) | ||
| 55892 | 55892 | 101149 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 455 Arkansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x4 | 6012981.15639 | 2104998.3662 | 37.760655124349796 | -122.398188689753 | (37.7606551243498, -122.398188689753) | |||
| 55998 | 55998 | 31018 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43762 | 6002296.8403 | 2087180.6482 | 37.711130859472604 | -122.433867290956 | (37.7111308594726, -122.433867290956) | |
| 57659 | 57659 | 56730 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1551 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015631.7584 | 2095701.0969999998 | 37.7352740434099 | -122.388372450522 | (37.7352740434099, -122.388372450522) | ||||
| 58099 | 58099 | 53509 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 4 | Permit Number 12537 | 6016318.8998 | 2092822.1194 | 37.7274069963434 | -122.385796126204 | (37.7274069963434, -122.385796126204) | ||
| 58328 | 58328 | 64440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 86 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1988 12:00:00 AM | 9 | Permit Number 25302 | 6004572.18453 | 2093022.2791099998 | 37.7272995637139 | -122.426418806283 | (37.7272995637139, -122.426418806283) | ||
| 58826 | 58826 | 38560 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1539 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40525 | 6015686.9214 | 2095659.8019 | 37.7351637119843 | -122.388178849076 | (37.7351637119843, -122.388178849076) | |
| 58880 | 58880 | 43337 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 8 | Permit Number 43094 | 6003321.30466 | 2090952.47585 | 37.7215455546665 | -122.430595462026 | (37.7215455546665, -122.430595462026) | |
| 58961 | 58961 | 31221 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 766 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34908 | 5981084.03491617 | 2110503.52214182 | 37.773942382229706 | -122.50891323703699 | (37.7739423822297, -122.508913237037) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");