trees
1,794 rows where qSpecies_id = 95 sorted by PermitNotes descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33595 | 54076 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1684 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 12 | Permit Number 9799 | 5981309.7555 | 2103628.6509 | 37.7550792755366 | -122.507622210407 | (37.7550792755366, -122.507622210407) | 1 | 8 | 3 | 56 | 35 | ||
59039 | 54073 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1668 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 11 | Permit Number 9796 | 5981306.2414 | 2103720.476 | 37.7553311941305 | -122.507641176321 | (37.7553311941305, -122.507641176321) | 1 | 8 | 3 | 56 | 35 | ||
144266 | 54066 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1636 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 10 | Permit Number 9789 | 5981299.5188 | 2103912.0712 | 37.7558568639886 | -122.507678641222 | (37.7558568639886, -122.507678641222) | 1 | 8 | 3 | 56 | 35 | ||
8786 | 185918 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 785560 | 5985010.0046 | 2101432.1223 | 37.7492655031785 | -122.49466394117 | (37.7492655031785, -122.49466394117) | 1 | 8 | 3 | 29491 | 35 | |
14268 | 185920 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 785560 | 5985028.47 | 2101445.6998 | 37.7493038640631 | -122.494601089239 | (37.7493038640631, -122.494601089239) | 1 | 8 | 3 | 29491 | 35 | |
18192 | 185921 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 785560 | 5985000.7719 | 2101441.8981 | 37.7492918044482 | -122.49469658817 | (37.7492918044482, -122.49469658817) | 1 | 8 | 3 | 29491 | 35 | |
18749 | 227563 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4565 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 784780 | 6000806.39418 | 2104634.53115 | 37.7589704630323 | -122.440269497142 | (37.7589704630323, -122.440269497142) | 2 | 4 | 5 | 28862 | 38 | ||
169370 | 255812 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1258 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | Permit Number 782103 | 5999099 | 2105411 | 37.7610050950906 | -122.446230300301 | (37.7610050950906, -122.446230300301) | 15 | 5 | 5 | 28862 | 3 | |||
11806 | 233511 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782005 | 6004633.78606 | 2109456.48744 | 37.7724275683009 | -122.427376074351 | (37.7724275683009, -122.427376074351) | 7 | 9 | 11 | 28852 | 10 | |
129496 | 255714 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 618x Mendell St | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016376 | 2097269 | 37.7396204009215 | -122.385908564927 | (37.7396204009215, -122.385908564927) | 10 | 3 | 8 | 58 | 1 | |||
4524 | 183636 | Planning Code 138.1 required 2 | Pittosporum crassifolium :: Karo Tree 95 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x9 | Permit Number 781673 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | 1 | 8 | 3 | 56 | 35 | |
146270 | 123242 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 590 08th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 780398 | 5993480.94596 | 2111487.08691 | 37.7773659721383 | -122.466102092728 | (37.7773659721383, -122.466102092728) | 11 | 6 | 2 | 54 | 11 | ||
31343 | 233540 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 660 Clipper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001114.06108 | 2100904.6606 | 37.7487466507355 | -122.438938144387 | (37.7487466507355, -122.438938144387) | 2 | 4 | 5 | 28862 | 22 | |
38847 | 233542 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 660 Clipper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001023.66433 | 2100904.77572 | 37.748741823193 | -122.439250743354 | (37.748741823193, -122.439250743354) | 2 | 4 | 5 | 28862 | 22 | |
143292 | 233541 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 660 Clipper St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001052.25493 | 2100904.1832 | 37.7487418231882 | -122.439151834995 | (37.7487418231882, -122.439151834995) | 2 | 4 | 5 | 28862 | 22 | |
130055 | 114304 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2508 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778637 | 6007480.44812 | 2121087.8604 | 37.8045250511575 | -122.41835402794 | (37.8045250511575, -122.41835402794) | 5 | 1 | 1 | 308 | 32 | ||
137357 | 117353 | Private 9 | Pittosporum crassifolium :: Karo Tree 95 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.7710574836343 | -122.390397474374 | (37.7710574836343, -122.390397474374) | 14 | 3 | 9 | 310 | 20 | |||
180968 | 104653 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2672 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 770419 | 5986744.1955 | 2097207.4042 | 37.7377669065018 | -122.488356720902 | (37.7377669065018, -122.488356720902) | 1 | 8 | 3 | 29491 | 35 | ||
143838 | 47861 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1425 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769441 | 5982751.53943123 | 2105417.90744548 | 37.7600769004648 | -122.502768627187 | (37.7600769004648, -122.502768627187) | 1 | 8 | 3 | 56 | 35 | |
95493 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 701 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | 10 | 3 | 8 | 28856 | 29 | |||
66091 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
100606 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 3 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
67766 | 9918 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
92769 | 9919 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
15360 | 94683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1496 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53823 | 5980955.2273 | 2104911.2096 | 37.7585799229956 | -122.508943475923 | (37.7585799229956, -122.508943475923) | 1 | 8 | 3 | 56 | 35 |
11325 | 92820 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4410 Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53029 | 5993333.8 | 2112848.6 | 37.7810958286268 | -122.466710108029 | (37.7810958286268, -122.466710108029) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
98418 | 46394 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1978 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51551 | 5982308.3388 | 2101642.3075 | 37.7496841114633 | -122.504021759577 | (37.7496841114633, -122.504021759577) | 1 | 8 | 3 | 29491 | 35 | |
154901 | 83220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4431 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51278 | 5981138.26503887 | 2104833.82596272 | 37.7583782380396 | -122.508304716049 | (37.7583782380396, -122.508304716049) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
69066 | 83404 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4161-4165 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50774 | 6002116.5949366 | 2102338.3887788 | 37.7527403167837 | -122.435573947989 | (37.7527403167837, -122.435573947989) | 2 | 4 | 5 | 28862 | 22 | ||
65349 | 83246 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
81945 | 83247 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
128960 | 81950 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
20766 | 84183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 496 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50711 | 6010074.8980178 | 2089472.05898173 | 37.7178609244136 | -122.407145708761 | (37.7178609244136, -122.407145708761) | 10 | 7 | 8 | 309 | 39 | ||
23641 | 43313 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.7261197629015 | -122.431680307904 | (37.7261197629015, -122.431680307904) | 9 | 7 | 6 | 28861 | 5 |
123128 | 43311 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003068.93568 | 2092663.25214 | 37.7262286645003 | -122.431589908071 | (37.7262286645003, -122.431589908071) | 9 | 7 | 6 | 28861 | 5 |
149448 | 43312 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.431640671199 | (37.7261742132654, -122.431640671199) | 9 | 7 | 6 | 28861 | 5 |
153384 | 43310 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 150X Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6002773.36898986 | 2092525.07870875 | 37.7258325139415 | -122.432601800105 | (37.7258325139415, -122.432601800105) | 9 | 7 | 6 | 28861 | 5 |
75088 | 80866 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50662 | 6003060.92852227 | 2092556.70085542 | 37.7259356446911 | -122.43160998466 | (37.7259356446911, -122.43160998466) | 9 | 7 | 6 | 28861 | 5 | ||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
9102 | 83833 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
115361 | 83929 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
155144 | 83804 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1930 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50176 | 5981678.3666 | 2101922.0131 | 37.7504150384206 | -122.506220927159 | (37.7504150384206, -122.506220927159) | 1 | 8 | 3 | 29491 | 35 | |
45533 | 79908 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4668 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50048 | 6000123.33109091 | 2105202.65192777 | 37.7604914689072 | -122.442672635485 | (37.7604914689072, -122.442672635485) | 15 | 4 | 5 | 28862 | 3 | ||
164961 | 81981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 468 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49994 | 5982862.28104 | 2112646.79088 | 37.779931837918 | -122.502920784353 | (37.779931837918, -122.502920784353) | 11 | 6 | 2 | 55 | 26 | |
53963 | 84931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
4444 | 53046 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 316@ MURRY Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2006 12:00:00 AM | Permit Number 49024 | 6006622.35600202 | 2096030.08358055 | 37.7356740165253 | -122.419544661787 | (37.7356740165253, -122.419544661787) | 2 | 7 | 7 | 28859 | 2 | ||
90463 | 51043 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1559 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 1 | Permit Number 48663 | 5983718.7515 | 2104538.8044 | 37.7577199248109 | -122.49935859222 | (37.7577199248109, -122.49935859222) | 1 | 8 | 3 | 56 | 35 | |
155794 | 52524 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | Permit Number 48624 | 6000729.49329 | 2092545.62188 | 37.7257727999708 | -122.439668786882 | (37.7257727999708, -122.439668786882) | 9 | 7 | 6 | 28861 | 25 | |
110142 | 251675 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 3x3 | Permit Number 48036 | 6001586 | 2113871 | 37.784375861656 | -122.438234943981 | (37.784375861656, -122.438234943981) | 15 | 6 | 11 | 29490 | 13 | ||
163553 | 51787 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 2x2 | Permit Number 48036 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||
189618 | 33530 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 173 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/13/2005 12:00:00 AM | Permit Number 48005 | 6007338.9559133 | 2098056.09080214 | 37.7412773227891 | -122.417210613498 | (37.7412773227891, -122.417210613498) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
62103 | 51010 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1501REVISED 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2006 12:00:00 AM | Permit Number 47487 | 5994268.09376771 | 2105301.29458407 | 37.7604267957909 | -122.462930216255 | (37.7604267957909, -122.462930216255) | 1 | 5 | 4 | 56 | 12 | ||
140970 | 50962 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2544 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47454 | 6007484.88144152 | 2121079.14108349 | 37.8045013596833 | -122.418338067384 | (37.8045013596833, -122.418338067384) | 5 | 1 | 1 | 308 | 32 | ||||
107589 | 50917 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1758 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47419 | 5990355.53399415 | 2103415.39072079 | 37.7550224657488 | -122.476324048759 | (37.7550224657488, -122.476324048759) | 1 | 8 | 4 | 56 | 12 | ||
184444 | 50896 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1647 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47405 | 5990863.99399476 | 2104190.85036451 | 37.7571811470474 | -122.474622258806 | (37.7571811470474, -122.474622258806) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||
107187 | 50782 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1191 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2004 12:00:00 AM | Permit Number 47308 | 6008219.78042798 | 2115855.19241784 | 37.7901990348064 | -122.415424817486 | (37.7901990348064, -122.415424817486) | 5 | 1 | 10 | 28858 | 21 | ||
102680 | 50457 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 336 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47102 | 6003706.69547569 | 2099554.47375445 | 37.7451865213865 | -122.429876537024 | (37.7451865213865, -122.429876537024) | 2 | 7 | 5 | 63 | 22 | |||
103335 | 50395 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 127 Riverton Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 1 | Permit Number 47046 | 5987033.45591 | 2095011.41616 | 37.7317541720083 | -122.487195376871 | (37.7317541720083, -122.487195376871) | 1 | 8 | 4 | 64 | 35 | |
46376 | 50221 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5024 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46928 | 5987740.46157 | 2109864.25645 | 37.7725772775948 | -122.48584090834 | (37.7725772775948, -122.48584090834) | 11 | 6 | 2 | 55 | 26 |
192612 | 50116 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46841 | 5990949.33787022 | 2098364.95753208 | 37.7411897083484 | -122.473902084012 | (37.7411897083484, -122.473902084012) | 1 | 8 | 4 | 29491 | 40 | ||
153041 | 50115 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1644 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46840 | 5990947.45576914 | 2098416.9234603 | 37.7413322844264 | -122.473912381937 | (37.7413322844264, -122.473912381937) | 1 | 8 | 4 | 29491 | 40 | ||
67869 | 43159 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 252 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 7 | Permit Number 46761 | 6006227.85589 | 2092666.05204 | 37.7264148961281 | -122.42066986853 | (37.7264148961281, -122.42066986853) | 9 | 7 | 7 | 309 | 5 | |
11743 | 50027 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
20039 | 50025 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
140060 | 50026 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
155941 | 50022 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 736 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3 | Permit Number 46756 | 6009379.93201 | 2091040.43268 | 37.7221284349621 | -122.409658546911 | (37.7221284349621, -122.409658546911) | 9 | 3 | 7 | 309 | 28 | |
121945 | 49984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3SEA CLIFF 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46731 | 5988218.33044294 | 2115911.3812309 | 37.7892088105604 | -122.484631586183 | (37.7892088105604, -122.484631586183) | 11 | 6 | 1 | 61 | 33 | |||
112810 | 49950 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1680 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | Permit Number 46706 | 5985923.93162312 | 2095914.5816821 | 37.7341692652739 | -122.491097616053 | (37.7341692652739, -122.491097616053) | 1 | 8 | 3 | 64 | 35 | ||
2234 | 49760 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 366@ REY Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46555 | 6008968.34582 | 2087920.09571 | 37.7135375657916 | -122.410861035806 | (37.7135375657916, -122.410861035806) | 9 | 7 | 8 | 309 | 39 | |
138139 | 49755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1143 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46551 | 6011336.45006 | 2089464.63362 | 37.7179110561333 | -122.402784534778 | (37.7179110561333, -122.402784534778) | 10 | 7 | 8 | 309 | 39 | |
2767 | 49750 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011291.8839 | 2088250.88482 | 37.714575859155 | -122.402853264575 | (37.714575859155, -122.402853264575) | 10 | 7 | 8 | 309 | 39 | |
43998 | 49749 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46548 | 6011339.97378405 | 2088277.54861548 | 37.7146517576713 | -122.402688919521 | (37.7146517576713, -122.402688919521) | 10 | 7 | 8 | 309 | 39 | ||
53354 | 49751 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011264.41643 | 2088242.20355 | 37.7145504883813 | -122.402947593582 | (37.7145504883813, -122.402947593582) | 10 | 7 | 8 | 309 | 39 | |
93059 | 49752 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011250.71045 | 2088239.22111 | 37.7145415338455 | -122.402994757601 | (37.7145415338455, -122.402994757601) | 10 | 7 | 8 | 309 | 39 | |
56131 | 49690 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 450 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | 3x3 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |
108910 | 49653 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | 5 | Permit Number 46506 | 6010094.54091 | 2089412.62479 | 37.71769882961 | -122.407073624648 | (37.71769882961, -122.407073624648) | 9 | 7 | 8 | 309 | 39 | |
157025 | 37788 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2003 12:00:00 AM | 5 | Permit Number 46497 | 6009357.10808 | 2092858.09097 | 37.7271180634226 | -122.409865688662 | (37.7271180634226, -122.409865688662) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
84494 | 49046 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 115 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46219 | 5996108.27017141 | 2093728.07837669 | 37.7287554301635 | -122.455729350835 | (37.7287554301635, -122.455729350835) | 9 | 7 | 4 | 28861 | 40 | ||
121400 | 49047 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46219 | 5996108.27017141 | 2093728.07837669 | 37.7287554301635 | -122.455729350835 | (37.7287554301635, -122.455729350835) | 9 | 7 | 4 | 28861 | 40 | ||
55849 | 48560 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4140 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45980 | 5991967.17199853 | 2088459.93536695 | 37.7140518790132 | -122.469661899743 | (37.7140518790132, -122.469661899743) | 9 | 8 | 6 | 64 | 24 | ||
57786 | 48561 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4140 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45980 | 5991967.17199853 | 2088459.93536695 | 37.7140518790132 | -122.469661899743 | (37.7140518790132, -122.469661899743) | 9 | 8 | 6 | 64 | 24 | ||
168145 | 48651 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 436 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45944 | 5992984.82174841 | 2103929.91361967 | 37.756587341409 | -122.467268706379 | (37.756587341409, -122.467268706379) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||
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 | ||
145032 | 47967 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 370 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45697 | 5997970.64208959 | 2098199.91881065 | 37.7411407391747 | -122.449613145498 | (37.7411407391747, -122.449613145498) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||
86178 | 47837 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 548 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45599 | 5981333.02429 | 2111993.22648 | 37.7780473459501 | -122.508162548327 | (37.7780473459501, -122.508162548327) | 11 | 6 | 2 | 55 | 26 | |
90275 | 47584 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | Permit Number 45429 | 6002167.38030416 | 2107035.22684309 | 37.7656395833099 | -122.435734334425 | (37.7656395833099, -122.435734334425) | 15 | 5 | 5 | 28862 | 3 | |||
40517 | 47441 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 626 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45352 | 5982593.98517 | 2111497.14443 | 37.7767594734686 | -122.503763757103 | (37.7767594734686, -122.503763757103) | 11 | 6 | 2 | 55 | 26 | |
67602 | 37789 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2002 12:00:00 AM | 5 | Permit Number 45187 | 6009352.7648 | 2092869.00605 | 37.7271477905118 | -122.409881473561 | (37.7271477905118, -122.409881473561) | 10 | 3 | 7 | 309 | 28 | ||
105629 | 47188 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 107 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45148 | 5987375.30823388 | 2115250.42635367 | 37.7873448881099 | -122.487499729264 | (37.7873448881099, -122.487499729264) | 11 | 6 | 1 | 55 | 33 | ||
26165 | 47182 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 212 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 4 | Permit Number 45143 | 5987760.61225 | 2114510.1816 | 37.7853348512586 | -122.48611231452 | (37.7853348512586, -122.48611231452) | 11 | 6 | 2 | 55 | 26 | |
34085 | 47183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 212 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 4 | 3x3 | Permit Number 45143 | 5987760.75968345 | 2114545.12215394 | 37.7854307966382 | -122.486114370266 | (37.7854307966382, -122.486114370266) | 11 | 6 | 2 | 55 | 26 |
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) );